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.
>
>
>