NETTYPE NET/CPU

Version: IDS 10 I am trying to understand NETTYPE better so that we can configure our connections appropriately and perhaps make it more efficient. My questions is: 1. Is VP Class NET synonymous to OS's CPU and Vp Class CPU synonymous to oninit. 2. After reading about Vp Class my understanding is that ipcshm protocol should be configured for CPU vp class. Is that correct ? What's the benefit of using one over other 3. And should soctcp protocol be configured for NET vp class. Is that correct ? What's the benefit of using one over other 4. Also, when I do onstat -g glo I see lot of cpu type virtual processors having total of more than 100. On IBM's website they recommend adding one more cpu if total is more than 100, but our application seems to be fine. So I am little bit confused about this too.

On Aug 8, 8:57 pm, mohitanch...@gmail.com wrote: > Version: IDS 10 I'll leave you mostly with Jonathan's entries and just add a bit as well. For a full explanation of why to use CPU VPs versus NET VPs for listeners, see my entry on the subject in the full Informix FAQ (not Jonathan's CDI FAQ) - link on the IIUG WEB site (www.iiug.org). See below: > I am trying to understand NETTYPE better so that we can configure our > connections appropriately and perhaps make it more efficient. My > questions is: > > 1. Is VP Class NET synonymous to OS's CPU and Vp Class CPU synonymous > to oninit. > 2. After reading about Vp Class my understanding is that ipcshm > protocol should be configured for CPU vp class. Is that correct ? > What's the benefit of using one over other The CPU VP has work to do so it can only poll the ports for new connections and for new requests from existing connections when it's waiting for something to happen. That makes it less than ideal for network connections, but is a plus for shared memory connections because a NET VP has to actively poll a shared memory connection which burns CPU time and OS Kernel time reducing the available cycles for productive work. Because CPU VPs can only poll periodically all CPU VPs should be set up with shared memory poll threads for optimal responsiveness. > 3. And should soctcp protocol be configured for NET vp class. Is that > correct ? What's the benefit of using one over other > 4. Also, when I do onstat -g glo I see lot of cpu type virtual > processors having total of more than 100. On IBM's website they > recommend adding one more cpu if total is more than 100, but our > application seems to be fine. So I am little bit confused about this > too. Art S. Kagel

On Aug 9, 6:50 am, "Art S. Kagel" <art.ka...@gmail.com> wrote: > On Aug 8, 8:57 pm, mohitanch...@gmail.com wrote: > > > Version: IDS 10 > > I'll leave you mostly with Jonathan's entries and just add a bit as > well. For a full explanation of why to use CPU VPs versus NET VPs for > listeners, see my entry on the subject in the fullInformixFAQ (not > Jonathan's CDI FAQ) - link on the IIUG WEB site (www.iiug.org). > > See below: > > > I am trying to understand NETTYPE better so that we can configure our > > connections appropriately and perhaps make it more efficient. My > > questions is: > > > 1. Is VP Class NET synonymous to OS's CPU and Vp Class CPU synonymous > > to oninit. > > 2. After reading about Vp Class my understanding is that ipcshm > > protocol should be configured for CPU vp class. Is that correct ? > > What's the benefit of using one over other > > The CPU VP has work to do so it can only poll the ports for new > connections and for new requests from existing connections when it's > waiting for something to happen. That makes it less than ideal for > network connections, but is a plus for shared memory connections > because a NET VP has to actively poll a shared memory connection which > burns CPU time and OS Kernel time reducing the available cycles for > productive work. Because CPU VPs can only poll periodically all CPU > VPs should be set up with shared memory poll threads for optimal > responsiveness. > > > 3. And should soctcp protocol be configured for NET vp class. Is that > > correct ? What's the benefit of using one over other > > 4. Also, when I do onstat -g glo I see lot of cputypevirtual > > processors having total of more than 100. On IBM's website they > > recommend adding one more cpu if total is more than 100, but our > > application seems to be fine. So I am little bit confused about this > > too. > > Art S. Kagel Makes it more clear. However, I have few more questions: 1. If an application runs on the same box as Informix then does it connect through socket or uses shared memory directly. Reason I am asking is because in sqlhosts file I see entry one for shm and other for tcp for same box. 2. Is there a way to see how many CPU vps and NET vps are running and how it's being used. I tried onstat -g glo but didn't quite understand how to intepret it. 3. How to determine how many CPU or NET vps to use, assumiing 100 connections created by remote hosts and around 400 on same hosts and machine having CPU of 10 with 30 GB memory. I am trying to determine what would be best if we have to acquire new machine.

On Thu, 2007-08-09 at 09:31 -0700, mohitanchlia@gmail.com wrote: > 1. If an application runs on the same box as Informix then does it > connect through socket or uses shared memory directly. Reason I am > asking is because in sqlhosts file I see entry one for shm and other > for tcp for same box. See $INFORMIXSERVER. -- Carsten Haese http://informixdb.sourceforge.net