NUMCPUVPS

We have a two server cluster environment. Another server is for Baan application and another is for Informix database. Informix version is 7.31 FC2. Both servers are HP N 4000 (6 CPU) with HP-UX 11.0. Now users are reported to us that application is getting slower. Application server runs 50-60% Idle time almost whole day. Database server runs only 10-15 % Idle time during rush ours. Oninit processes are first on top listing. **************************************************************************** What is the right value for parameter NUMCPUVPS ? Now is is same as physical processor number (6) There are two onstat listings. (measuring interval 3670 sec) Onstat -p Up 2 days 23:58:56 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 39043.25 109627.06 1957 4274 Up 3 days 01:00:06 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 41719.61 121013.40 1987 4334 Thanks for your advice!

Post your onconfig file. Do you have NOAGE set? That is VERY important on HPUX which is brutally aggressive about aging long running processes like the oninits that Informix starts up. Next, was this an upgrade from 7.2x? Post COMPLETE onstat -p listing along with: onstat -P|tail onstat -g iov onstat -g ioq onstat -g seg onstat -g glo NUMCPUVPS should be 1 less than the number of CPUS in general, however, on CPUs faster than about 400 MHZ (600 for Intel) some have reported improvements up to 2x number of CPUs. Art S. Kagel Masa wrote: > > We have a two server cluster environment. Another server is for Baan > application and another is for Informix database. > Informix version is 7.31 FC2. Both servers are HP N 4000 (6 CPU) with HP-UX > 11.0. > > Now users are reported to us that application is getting slower. > > Application server runs 50-60% Idle time almost whole day. Database server > runs only 10-15 % Idle time during rush ours. > Oninit processes are first on top listing. > > **************************************************************************** > > What is the right value for parameter NUMCPUVPS ? > > Now is is same as physical processor number (6) > > There are two onstat listings. (measuring interval 3670 sec) > Onstat -p > > Up 2 days 23:58:56 > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 39043.25 109627.06 1957 4274 > > Up 3 days 01:00:06 > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 41719.61 121013.40 1987 4334 > > Thanks for your advice!

Wonder what's causing Informix's syscpu to be 4 times that of usercpu - normally, its the reverse. Post onstat -c as well as the other onstat's suggested. Rudy Masa wrote: > Up 2 days 23:58:56 > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 39043.25 109627.06 1957 4274 > > Up 3 days 01:00:06 > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 41719.61 121013.40 1987 4334