KAIO and HPUX 11.0 with multiple Informix 7.31 instances

Has anyone seen a problem with multiple informix engines on HPUX 11.0? My question is mainly that it appears our main production engine is set to use KAIO and it looks to me like it is configured to use the entire HPUX box (K260-4way with 2.5GB RAM). The onconf.dbname for each instance is set the exact same. This might be great for one instance, but whenever I try to bring up a second instance, I start getting bus error, core dump. HP is stumped, and I think it is a configuration problem in the engines. Also swapinfo is going from 11% to 89%. After a reboot, 11% then it goes up steadily till about 89% by Sunday, and I reboot Monday morning and start the process again. This may or may not be connected. Has anyone exerienced this, and what fixes it? # System Configuration SERVERNUM 2 # Unique id corresponding to a Dynamic Serverinstance DBSERVERNAME cras # Name of default database server DBSERVERALIASES crasitcp # List of alternate dbservernames NETTYPE ipcshm,1,250,CPU # Configure poll thread(s) for nettype NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor NUMCPUVPS 3 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number of processors # Shared Memory Parameters LOCKS 256000 # Maximum number of locks BUFFERS 10000 # Maximum number of shared buffers NUMAIOVPS 14 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 100 # Maximum number of logical log files CLEANERS 4 # Number of buffer cleaner processes SHMBASE 0x0 # Shared memory base address SHMVIRTSIZE 92000 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments (Kbytes) SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited CKPTINTVL 900 # Check point interval (in sec) LRUS 10 # Number of LRU queues LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit LTXHWM 45 # Long transaction high water mark percentage LTXEHWM 55 # Long transaction high water mark (exclusive) TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 32 # Stack size (Kbytes) TIA Larry Romo Programmer and other duties as assigned, such as HPUX systems Admin and Informix DBA.

It works fine for me, IDS 9.20 FC2 on HP-UX 11.0 Your SHMVIRTSIZE looks very small. Do you notice further segments being allocated (via onstat -m, or onstat -g seg)? If so, you should increase the size of SHMVIRTSIZE until this doesn't happen. Also, although not realted to your problem, with the physical memory you have you should be able to afford a much higher value of BUFFERS - say 100,000 to start with? Pxllr <pxllr@aol.com> wrote in message news:20010129184239.11105.00001252@ng-cg1.aol.com... > Has anyone seen a problem with multiple informix engines on HPUX 11.0? My > question is mainly that it appears our main production engine is set to use > KAIO and it looks to me like it is configured to use the entire HPUX box > (K260-4way with 2.5GB RAM). The onconf.dbname for each instance is set the > exact same. This might be great for one instance, but whenever I try to bring > up a second instance, I start getting bus error, core dump. HP is stumped, and > I think it is a configuration problem in the engines. > Also swapinfo is going from 11% to 89%. After a reboot, 11% then it goes up > steadily till about 89% by Sunday, and I reboot Monday morning and start the > process again. This may or may not be connected. > Has anyone exerienced this, and what fixes it? > > # System Configuration > > SERVERNUM 2 # Unique id corresponding to a DynamicServer > instance > DBSERVERNAME cras # Name of default database server > DBSERVERALIASES crasitcp # List of alternate dbservernames > NETTYPE ipcshm,1,250,CPU # Configure poll thread(s) for nettype > NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype > DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. > RESIDENT 1 # Forced residency flag (Yes = 1, No = 0) > > MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor > NUMCPUVPS 3 # Number of user (cpu) vps > SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps toone > > NOAGE 1 # Process aging > AFF_SPROC 0 # Affinity start processor > AFF_NPROCS 0 # Affinity number of processors> > # Shared Memory Parameters > > LOCKS 256000 # Maximum number of locks > BUFFERS 10000 # Maximum number of shared buffers > NUMAIOVPS 14 # Number of IO vps > PHYSBUFF 32 # Physical log buffer size (Kbytes) > LOGBUFF 32 # Logical log buffer size (Kbytes)> LOGSMAX 100 # Maximum number of logical log files > CLEANERS 4 # Number of buffer cleaner processes > SHMBASE 0x0 # Shared memory base address > SHMVIRTSIZE 92000 # initial virtual shared memory segmentsize > SHMADD 8192 # Size of new shared memory segments (Kbytes) > SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited > CKPTINTVL 900 # Check point interval (in sec) > LRUS 10 # Number of LRU queues > LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning limit > LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit > LTXHWM 45 # Long transaction high water markpercentage > LTXEHWM 55 # Long transaction high water mark (exclusive) > TXTIMEOUT 0x12c # Transaction timeout (in sec) > STACKSIZE 32 # Stack size (Kbytes)> > TIA > Larry Romo > Programmer and other duties as assigned, such as HPUX systems Admin and > Informix DBA.

In article <20010129184239.11105.00001252@ng-cg1.aol.com>, Pxllr <pxllr@aol.com> writes >Has anyone seen a problem with multiple informix engines on HPUX 11.0? My >question is mainly that it appears our main production engine is set to use >KAIO and it looks to me like it is configured to use the entire HPUX box >(K260-4way with 2.5GB RAM). The onconf.dbname for each instance is set the >exact same. This might be great for one instance, but whenever I try to bring >up a second instance, I start getting bus error, core dump. HP is stumped, and >I think it is a configuration problem in the engines. >Also swapinfo is going from 11% to 89%. After a reboot, 11% then it goes up >steadily till about 89% by Sunday, and I reboot Monday morning and start the >process again. This may or may not be connected. >Has anyone exerienced this, and what fixes it? > ># System Configuration > >SERVERNUM 2 # Unique id corresponding to a Dynamic Server>instance You can't have two instances with the same servernum! >DBSERVERNAME cras # Name of default database server >DBSERVERALIASES crasitcp # List of alternate dbservernames >NETTYPE ipcshm,1,250,CPU # Configure poll thread(s) for nettype >NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype >DEADLOCK_TIMEOUT 60 # Max time to wait of lock in distributed env. >RESIDENT 1 # Forced residency flag (Yes = 1, No = 0)> RESIDENT=1 means Informix tries to pin the shared memory into physical memory i.e. make the shared memory unswapable. You probably do not have enough physical memory to maek this possible. Try boot the seconds instance with oninit -v this undocumented option shows more info on how online starts up. >MULTIPROCESSOR 1 # 0 for single-processor, 1 for multi-processor >NUMCPUVPS 3 # Number of user (cpu) vps >SINGLE_CPU_VP 0 # If non-zero, limit number of cpu vps to one > >NOAGE 1 # Process aging >AFF_SPROC 0 # Affinity start processor >AFF_NPROCS 0 # Affinity number of processors> ># Shared Memory Parameters > >LOCKS 256000 # Maximum number of locks >BUFFERS 10000 # Maximum number of shared buffers >NUMAIOVPS 14 # Number of IO vps >PHYSBUFF 32 # Physical log buffer size (Kbytes) >LOGBUFF 32 # Logical log buffer size (Kbytes)>LOGSMAX 100 # Maximum number of logical log files >CLEANERS 4 # Number of buffer cleaner processes >SHMBASE 0x0 # Shared memory base address >SHMVIRTSIZE 92000 # initial virtual shared memory segment size >SHMADD 8192 # Size of new shared memory segments (Kbytes) >SHMTOTAL 0 # Total shared memory (Kbytes). 0=>unlimited >CKPTINTVL 900 # Check point interval (in sec) >LRUS 10 # Number of LRU queues >LRU_MAX_DIRTY 10 # LRU percent dirty begin cleaning limit >LRU_MIN_DIRTY 5 # LRU percent dirty end cleaning limit >LTXHWM 45 # Long transaction high water mark percentage >LTXEHWM 55 # Long transaction high water mark (exclusive) >TXTIMEOUT 0x12c # Transaction timeout (in sec) >STACKSIZE 32 # Stack size (Kbytes)> >TIA >Larry Romo >Programmer and other duties as assigned, such as HPUX systems Admin and >Informix DBA. -- David Williams