Performance Problems after Upgrade to 7.23UC6

Apolgies if this appears twice but I received an error sending it the = first time and wanted to make sure it made it. John DeSilva -----Original Message----- From: John DeSilva=20 Sent: Tuesday, March 31, 1998 9:46 AM To: 'informix-list@iiug.org' Subject: Performance Problems after Upgrade to 7.23UC6 ??????????? All suggestions greatly appreciated ??????????????? We have just recently upgrade a client machine from HPUX 9.04 / Online = 7.14UD1 to HPUX 10.20 Online 7.23UC6 and have suffered an incredible performance = drop in the process. The machine is a uniprocessor HP9000 G50 with 384 MB Ram. We were able = to run 40 - 44 users at very acceptable speeds under 7.14 but at around = 30 users under 7.23 the machine takes a serious nose dive ( 5 -10 times = slower ). We have contacted infomix tech support who had us dbexport/dbimport the = entire DB and run an update statistics. We also contacted HP who had us change the DBC_MAX_PCT kernal parameter = from 50% to 15% ( something to do with pseudoswap ). None of these have had any significant impact although the kernal = parameter did appear to have some affect. The primary bottleneck apears to be the CPU. Under sar -u the system and = user cpu usage are about equal at 50% with 0% appearing in wio and idle. Swapinfo shows us no swapping to the two swap devices that we have but a = new memory line showing 50% swapped ( again something to do with = pseudoswap according to HP ). All Online parameters were left the same as under 7.14. I have check those parameters which the 7.2 performance tuning guide say = affect CPU usage and all appear to be correct. The client has a new D370 2-way on order but it is not expected to = arrive for another 3 weeks with installation not due till the first week = of May. Has anyone had similar experiences with Online 7.23 and HPUX 10.20 ??? Any suggestions on what might be causing this and any possible solutions = ??? John DeSilva MCS Limited jads@mcs.bm