Fw: Connection type for transaction...
I'm posting again because I did not see it on the forum.
Perhaps I selected a different "To" address.
>
> >
> > Hi Listers,
> >
> > I was executing a restore script that drops the target table and the
loads
> > the records from an ascii file 300 at a time using dbload.
> > This is the result of running the following commands.
> > Since the data is being loaded into a table located on the same machine
as
> > the Informix instance (IDS 7.30 UC3), I thought it would be more
efficient
> > to use the shared memory connection. I know the NETTYPE parameters
define
> > the different type of connections, but what determines the type of
> > connection to use (we have one CPU) for a given SQL statement? Is there
a
> > default setting?
> >
> > bbankmain{opbzh}/usr/bank/opbzh>onstat -g ntu
> >
> > Informix Dynamic Server Version 7.30.UC3 -- On-Line (CKPT REQ) -- Up
29
> > days 0
> > 5:38:48 -- 267712 Kbytes
> > Blocked:CKPT
> >
> > global network information:
> > #netscb connects read write q-free q-limits q-exceed
> > 6/ 13 3967460 91548944 91647005 3/ 4 135/ 10 0/ 0
> >
> > Individual thread network information (basic):
> > netscb type thread name sid fd poll reads writes q-nrm
q-exp
> > 1302d788 tlitcp sqlexec 3964496 2 5 121953 121952 0/ 1
0/
> 0
> > 12a52818 tlitcp tlitcplst 7 1 5 3967460 0 0/ 0 0/
0
> > 12a39928 ipcshm sm_discon 6 0 0 0 0 0/ 0 0/
0
> > 12a38df8 ipcshm sm_listen 4 0 0 0 0 0/ 0 0/
0
> > 12a1bd98 tlitcp tlitcppoll 3 0 5 87810713 0 0/ 0 0/
0
> > 12a1a7d8 ipcshm sm_poll 2 0 0 0 0 0/ 0 0/
0
> >
> >
> > bbankmain{opbzh}/usr/bank/opbzh>onstat -u
> >
> > Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 29 days
> > 05:39:04 --
> > 267712 Kbytes
> >
> > Userthreads
> > address flags sessid user tty wait tout locks nreads
> > nwrites
> > 128b0018 ---P--D 1 informix - 0 0 0 10248
> > 152113
> > 128b04cc ---P--F 0 informix - 0 0 0 0
> > 3983281
> > 128b0980 ---P--F 0 informix - 0 0 0 0
> > 45961
> > 128b0e34 ---P--- 9 informix - 0 0 0 0
> 77
> > 128b12e8 ---P--B 10 informix - 0 0 0 109
> > 26213
> > 128b179c --BPX-- 3964496 opbzh 13 0 0 566 184971
> > 3465803
> > 128b2104 ---P--D 13 informix - 0 0 0 0
0
> > 7 active, 128 total, 19 maximum concurrent
> >
> > sqlhosts:
> > BB_IDS_MAIN oltlitcp 192.25.200.1 sqlturbo
> > BB_IDS_MAIN_shm olipcshm 192.25.200.1 srv_agent> >
> > onconfig:
> > NETTYPE tlitcp,1,50,CPU # Network conection type description
> > NETTYPE ipcshm,1,50,NET # Network conection type description> >
> > Hey, I just noticed that I have the NET type associated with "ipcshm"
and
> it
> > should be associated with "tlitcp" right?
> > What is the negative impact of a setting like this?
> >
> > Thanks in advance for your time.
> >
> > Regards,
> >
> > Denmark W.
> >
> >
> >
>