Re: Performance issues on HP-UX

On 7 Dec 2005 07:22:06 -0800, "Mike Peters" <mike.peters@mfs.misys.co.uk> wrote: >We are currently suffering performance problems with our Informix >server running on HP-UX. The server appears to be paging heavily with >sar -q showing %swpocc running at or close to 100. > That's not good . . . . and I'm presuming that vmstat is showing non-zero numbers for 'po' as well??? UNIX swapping is NOT GOOD for performance . . . . . 1G ram and about half or so given to Informix? What else is on this box? >The server is an HP 9000/800 with 1Gb RAM, running: >IBM Informix Dynamic Server Version 7.31.FD8 >HPUX Version B.11.11 > >At startup the online.log shows: > > 13:25:00 Segment locked: addr=0x5c5000, size=411049984 > 13:25:00 Segment locked: addr=0x18dc7000, size=115343360 > 13:25:01 The number of configured CPU poll threads exceeds>'NUMCPUVPS'. > NETTYPE 'live_sm' poll threads started on NET VPs. > >In our onconfig we have: > > NETTYPE ipcshm,2,150,CPU > NETTYPE soctcp,1,100,NET > > NUMCPUVPS 1> IDS is getting confused. It's expecting two CPU VP based on NETTYPE(ipcshm), but you're only giving it one based on NUMCPUVPS. Determine how many CPU VPs you want, then adjust MULTIPROCESSOR, SINGLE_CPU_VP and NUMCPUVPS accordingly. >>From the error message and googling I suppose we need to set NUMCPUVPS >to 2 (it is a dual processor machine). Some sources suggest setting the >vp class value to NET on a multi-processor machine. Is that the way to >go or should we stick with CPU? > Usually better to keep shm nettypes on CPU and tcp nettypes on NET. NUMCPUVPS can be 1 or 2. If the box is a dedicated db server, then set it to 2. >Additionally we are seeing occasional Network recieve errors in the >online.log and clients' telnet sessions are dropping with TCP errors. >However the dropped sessions do not always correspond to the Network >recieve errors in the logs: > > 12:00:37 listener-thread: err = -25587: oserr = 0: errstr = : Network>receive failed. > >Finally we are also seeing: > > 11:56:41 shmctl: errno = 12 > > 11:56:41 Shared memory segment 0xc00000001ffaf000 could not be forced >resident. > 11:57:03 hpkaioaddseg: ASYNC_ADDSEG failed, errno = 11 Resource>temporarily unavailable > 11:57:05 shmctl: errno = 12> >With regards the latter we have tried upping IFMX_HPKAIO_NUM_REQ to >3000 but that does not appear to have helped. Can anyone give us any >pointers to resolving these issues? Although performance is an issue, >the most urgent thing for us at the moment is stop the dropped >sessions. Our onconfig follows: > Have you verified that your network connections are consistent and not dropping packets?? Are you using 100/Full/autonegotiate off??? On another note. Is this a new server? Are you seeing multiple shared memory segments being allocated -- onstat -g seg -- ? HPUX doesn't like that . . . . . JWC