Fw: Connection type for transaction...
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.