Informix 7.31 on Windows NT4: nettype soctcp

Hello, If, on our Informix servers 7.31 on Windows NT4, I set the nettype parameter to "soctcp,2,300,NET" or "soctcp,2,300,CPU", I see no difference in the VP's that are started: soc threads are always started on SOC VP's. Is that normal? Output onstat -g glo: Informix Dynamic Server Version 7.31.TC6 -- On-Line -- Up 01:39:59 -- 596736 Kbytes MT global info: sessions threads vps lngspins 0 24 10 0 sched calls thread switches yield 0 yield n yield forever total: 0 0 8849077 12906 38685 per sec: 0 0 0 0 0 Virtual processor summary: class vps usercpu syscpu total cpu 2 3.28 1.15 4.43 aio 1 0.55 0.00 0.55 lio 1 0.55 0.00 0.55 pio 1 0.55 0.00 0.55 adm 1 0.00 0.00 0.00 soc 3 0.00 0.00 0.00 msc 1 0.55 0.00 0.55 total 10 5.48 1.15 6.63 Individual virtual processors: vp pid class usercpu syscpu total 1 139 cpu 2.90 1.12 4.02 2 175 adm 0.00 0.00 0.00 3 185 cpu 0.38 0.03 0.42 4 80 lio 0.55 0.00 0.55 5 252 pio 0.55 0.00 0.55 6 202 aio 0.55 0.00 0.55 7 206 msc 0.55 0.00 0.55 8 221 soc 0.00 0.00 0.00 9 218 soc 0.00 0.00 0.00 10 266 soc 0.00 0.00 0.00 tot 5.48 1.15 6.63 Output onstat -g ath: Informix Dynamic Server Version 7.31.TC6 -- On-Line -- Up 01:38:58 -- 596736 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 274e1e48 0 2 sleeping forever 4lio lio vp 0 3 2757a220 0 2 sleeping forever 5pio pio vp 0 4 2757a4b8 0 2 sleeping forever 6aio aio vp 0 5 2757a750 0 2 sleeping forever 7msc msc vp 0 6 2759e138 2748a018 4 sleeping secs: 1 1cpu main_loop() 7 2759ec30 0 2 running 8soc soctcppoll 8 2759f4a0 0 2 running 9soc soctcpio 9 2759fcc0 0 2 running 10soc soctcpio 10 275ba620 0 3 sleeping forever 3cpu soctcplst 11 275d6360 2748a500 2 sleeping forever 1cpu flush_sub(0) 12 275d65d0 2748a9e8 2 sleeping forever 3cpu flush_sub(1) 13 275d6840 2748aed0 2 sleeping forever 3cpu flush_sub(2) 14 275d6ab0 2748b3b8 2 sleeping forever 3cpu flush_sub(3) 15 275d6d20 2748b8a0 2 sleeping forever 3cpu flush_sub(4) 16 275d6f90 2748bd88 2 sleeping forever 3cpu flush_sub(5) 17 275d7200 2748c270 2 sleeping forever 3cpu flush_sub(6) 18 275d7470 2748c758 2 sleeping forever 3cpu flush_sub(7) 19 275d76e0 0 4 sleeping forever 6aio kaio 20 275d7cb8 0 4 sleeping forever 3cpu kaio 21 2760ec78 2748cc40 3 sleeping forever 3cpu aslogflush 22 2760efd8 2748d128 2 sleeping secs: 3 3cpu btclean 24 2760f5f8 0 4 sleeping forever 1cpu kaio 39 27646388 2748dfe0 4 sleeping secs: 1 1cpu onmode_mon 42 27668ff0 2748daf8 2 sleeping secs: 4 1cpu ontape

On windows, yes, all poll threads run in NET VPs. It is documented, but very subtly. In the Administrator's Reference section on NETTYPE it says: VP_class: CPU = CPU VPs (on UNIX) NET = Network VPs Note that it indicates that setting the VP class to CPU uses CPU VPs on UNIX. In implication is that on Windows it does NOT use CPU VPs. That's because, IIRC, there is only one CPU VP on windows that launches multiple CPU VP threads instead of multiple CPU VP processes. Personally I'd switch to Linux. ;-) Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Apr 28, 2009 at 7:18 AM, KURT VAN GOMPEL < kvangompel@caami-hziv.fgov.be> wrote: > Hello, > > If, on our Informix servers 7.31 on Windows NT4, I set the nettype > parameter > to "soctcp,2,300,NET" or "soctcp,2,300,CPU", I see no difference in the > VP's > that are started: soc threads are always started on SOC VP's. > Is that normal? > Output onstat -g glo: > Informix Dynamic Server Version 7.31.TC6 -- On-Line -- Up 01:39:59 -- > 596736 > Kbytes > > MT global info: > sessions threads vps lngspins > 0 24 10 0 > > sched calls thread switches yield 0 yield n yield forever > total: 0 0 8849077 12906 38685 > per sec: 0 0 0 0 0 > > Virtual processor summary: > class vps usercpu syscpu total > cpu 2 3.28 1.15 4.43 > aio 1 0.55 0.00 0.55 > lio 1 0.55 0.00 0.55 > pio 1 0.55 0.00 0.55 > adm 1 0.00 0.00 0.00 > soc 3 0.00 0.00 0.00 > msc 1 0.55 0.00 0.55 > total 10 5.48 1.15 6.63 > > Individual virtual processors: > vp pid class usercpu syscpu total > 1 139 cpu 2.90 1.12 4.02 > 2 175 adm 0.00 0.00 0.00 > 3 185 cpu 0.38 0.03 0.42 > 4 80 lio 0.55 0.00 0.55 > 5 252 pio 0.55 0.00 0.55 > 6 202 aio 0.55 0.00 0.55 > 7 206 msc 0.55 0.00 0.55 > 8 221 soc 0.00 0.00 0.00 > 9 218 soc 0.00 0.00 0.00 > 10 266 soc 0.00 0.00 0.00 > > tot 5.48 1.15 6.63 > > Output onstat -g ath: > > Informix Dynamic Server Version 7.31.TC6 -- On-Line -- Up 01:38:58 -- > 596736 > Kbytes > > Threads: > tid tcb rstcb prty status vp-class name > 2 274e1e48 0 2 sleeping forever 4lio lio vp 0 > 3 2757a220 0 2 sleeping forever 5pio pio vp 0 > 4 2757a4b8 0 2 sleeping forever 6aio aio vp 0 > 5 2757a750 0 2 sleeping forever 7msc msc vp 0 > 6 2759e138 2748a018 4 sleeping secs: 1 1cpu main_loop() > 7 2759ec30 0 2 running 8soc soctcppoll > 8 2759f4a0 0 2 running 9soc soctcpio > 9 2759fcc0 0 2 running 10soc soctcpio > 10 275ba620 0 3 sleeping forever 3cpu soctcplst > 11 275d6360 2748a500 2 sleeping forever 1cpu flush_sub(0) > 12 275d65d0 2748a9e8 2 sleeping forever 3cpu flush_sub(1) > 13 275d6840 2748aed0 2 sleeping forever 3cpu flush_sub(2) > 14 275d6ab0 2748b3b8 2 sleeping forever 3cpu flush_sub(3) > 15 275d6d20 2748b8a0 2 sleeping forever 3cpu flush_sub(4) > 16 275d6f90 2748bd88 2 sleeping forever 3cpu flush_sub(5) > 17 275d7200 2748c270 2 sleeping forever 3cpu flush_sub(6) > 18 275d7470 2748c758 2 sleeping forever 3cpu flush_sub(7) > 19 275d76e0 0 4 sleeping forever 6aio kaio > 20 275d7cb8 0 4 sleeping forever 3cpu kaio > 21 2760ec78 2748cc40 3 sleeping forever 3cpu aslogflush > 22 2760efd8 2748d128 2 sleeping secs: 3 3cpu btclean > 24 2760f5f8 0 4 sleeping forever 1cpu kaio > 39 27646388 2748dfe0 4 sleeping secs: 1 1cpu onmode_mon > 42 27668ff0 2748daf8 2 sleeping secs: 4 1cpu ontape > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001636c5ae018cffc704689c20a1

> Is that normal? Yes completion ports are used for network IO on Windows, and NET is the only supported net type. If you use CPU it will be changed back to NET internally. Regards Guy ________________________________ From: KURT VAN GOMPEL <kvangompel@caami-hziv.fgov.be> To: ids@iiug.org Sent: Tuesday, April 28, 2009 4:18:20 AM Subject: Informix 7.31 on Windows NT4: nettype soctcp [15628] Hello, If, on our Informix servers 7.31 on Windows NT4, I set the nettype parameter to "soctcp,2,300,NET" or "soctcp,2,300,CPU", I see no difference in the VP's that are started: soc threads are always started on SOC VP's. Is that normal? Output onstat -g glo: Informix Dynamic Server Version 7.31.TC6 -- On-Line -- Up 01:39:59 -- 596736 Kbytes MT global info: sessions threads vps lngspins 0 24 10 0 sched calls thread switches yield 0 yield n yield forever total: 0 0 8849077 12906 38685 per sec: 0 0 0 0 0 Virtual processor summary: class vps usercpu syscpu total cpu 2 3.28 1.15 4.43 aio 1 0.55 0.00 0.55 lio 1 0.55 0.00 0.55 pio 1 0.55 0.00 0.55 adm 1 0.00 0.00 0.00 soc 3 0.00 0.00 0.00 msc 1 0.55 0.00 0.55 total 10 5.48 1.15 6.63 Individual virtual processors: vp pid class usercpu syscpu total 1 139 cpu 2.90 1.12 4.02 2 175 adm 0.00 0.00 0.00 3 185 cpu 0.38 0.03 0.42 4 80 lio 0.55 0.00 0.55 5 252 pio 0.55 0.00 0.55 6 202 aio 0.55 0.00 0.55 7 206 msc 0.55 0.00 0.55 8 221 soc 0.00 0.00 0.00 9 218 soc 0.00 0.00 0.00 10 266 soc 0.00 0.00 0.00 tot 5.48 1.15 6.63 Output onstat -g ath: Informix Dynamic Server Version 7.31.TC6 -- On-Line -- Up 01:38:58 -- 596736 Kbytes Threads: tid tcb rstcb prty status vp-class name 2 274e1e48 0 2 sleeping forever 4lio lio vp 0 3 2757a220 0 2 sleeping forever 5pio pio vp 0 4 2757a4b8 0 2 sleeping forever 6aio aio vp 0 5 2757a750 0 2 sleeping forever 7msc msc vp 0 6 2759e138 2748a018 4 sleeping secs: 1 1cpu main_loop() 7 2759ec30 0 2 running 8soc soctcppoll 8 2759f4a0 0 2 running 9soc soctcpio 9 2759fcc0 0 2 running 10soc soctcpio 10 275ba620 0 3 sleeping forever 3cpu soctcplst 11 275d6360 2748a500 2 sleeping forever 1cpu flush_sub(0) 12 275d65d0 2748a9e8 2 sleeping forever 3cpu flush_sub(1) 13 275d6840 2748aed0 2 sleeping forever 3cpu flush_sub(2) 14 275d6ab0 2748b3b8 2 sleeping forever 3cpu flush_sub(3) 15 275d6d20 2748b8a0 2 sleeping forever 3cpu flush_sub(4) 16 275d6f90 2748bd88 2 sleeping forever 3cpu flush_sub(5) 17 275d7200 2748c270 2 sleeping forever 3cpu flush_sub(6) 18 275d7470 2748c758 2 sleeping forever 3cpu flush_sub(7) 19 275d76e0 0 4 sleeping forever 6aio kaio 20 275d7cb8 0 4 sleeping forever 3cpu kaio 21 2760ec78 2748cc40 3 sleeping forever 3cpu aslogflush 22 2760efd8 2748d128 2 sleeping secs: 3 3cpu btclean 24 2760f5f8 0 4 sleeping forever 1cpu kaio 39 27646388 2748dfe0 4 sleeping secs: 1 1cpu onmode_mon 42 27668ff0 2748daf8 2 sleeping secs: 4 1cpu ontape ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.