Re: dbaccess connect time difference between onipcshm and onsoctcp

Yasar Akman said: > t1:/>onstat -c | grep -i nettype > NETTYPE ipcshm,1,100,CPU # Override sqlhosts nettype parameters > NETTYPE soctcp,1,100,NET # Override sqlhosts nettype parameters Is this a single-CPU box? > t1:/>onstat -g ntu > > IBM Informix Dynamic Server Version 9.40.FC2X2 -- On-Line -- Up > 19:42:34 -- 385024 Kbytes> > global network information: > #netscb connects read write q-free q-limits q-exceed > alloc/max > 6/ 7 108 20245 60548 1/ 1 170/ 10 0/ 0 > 1/ 1 > > Individual thread network information (basic): > netscb type thread name sid fd poll reads writes > q-nrm q-pvt q-exp > 215dc0c78 soctcp soctcplst 8 2 5 0 0 > 0/ 0 0/ 0 0/ 0 > 215dbec28 soctcp soctcplst 7 1 5 42 0 > 0/ 0 0/ 0 0/ 0 > 215dbe3b0 ipcshm sm_discon 6 0 0 0 0 > 0/ 0 0/ 0 0/ 0 > 215dafc50 ipcshm sm_listen 4 0 0 66 0 > 0/ 0 0/ 0 0/ 0 > 215d9b5d0 soctcp soctcppoll 3 0 5 5880 0 > 0/ 0 0/ 0 0/ 0 > 215d875d0 ipcshm sm_poll 2 0 0 14378 0 > 0/ 0 0/ 0 0/ 0 > > > t1:/>onstat -g ntt > > IBM Informix Dynamic Server Version 9.40.FC2X2 -- On-Line -- Up > 19:42:44 -- 385024 Kbytes> > global network information: > #netscb connects read write q-free q-limits q-exceed > alloc/max > 6/ 7 108 20245 60548 1/ 1 170/ 10 0/ 0 > 1/ 1 > > Individual thread network information (times): > netscb thread name sid open read write address > 215dc0c78 soctcplst 8 13:16:47 > t1|1641|soctcp > 06/22/05 > 215dbec28 soctcplst 7 13:16:47 17:02:59 > t1|1541|soctcp > 06/22/05 06/22/05 > 215dbe3b0 sm_discon 6 13:16:47 > 06/22/05 > 215dafc50 sm_listen 4 13:16:47 > 06/22/05 > 215d9b5d0 soctcppoll 3 13:16:47 > 06/22/05 > 215d875d0 sm_poll 2 13:16:47 > 06/22/05 > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list

Yes, this single cpu box. hp DS15 alpha tru64 unix system with 2 GB memory