Re: NETTYPE NET/CPU

On 25 Aug, 06:35, mohitanch...@gmail.com wrote: > 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 understandNETTYPEbetter 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 > > Read more aboutNETTYPEand have few more questions: > > 1. What determines the polling cycle of poll thread having class of > CPU VP. You mentioned it polls only periodically. What does it do when > it's not polling ? It processes your sql. > 2. How do NET VP thread work for the clients that keep persistent > connection to database. Do each persistent connection take one poll > thread ? What happens when client is connected but is not querying or > working on DB. No each connection takes one "slot" in the list of connections handled by the poll thread. > 3. In IBM manual it mentions that each poll thread runs on separate > VP. Is VP synonymous to oninit ? So does it mean total number of poll > threads for shm and tcp combined together inNETTYPEcan't be more > than maximum number of VPs.- Hide quoted text - The maximum number of poll threads that run on cpu vps cannot exceed the number of cpu vps configured. You can run as many on net vps as you like, check the manual each net vp can handle 250-300 connections. > > - Show quoted text -