Re: Performance Problems after Upgrade to 7.23UC6

In article <6fqviv$nbl$1@news.xmission.com>, John DeSilva <jads@mcs.bm> writes > > ??????????? 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 = >??? > Check your $ONCONFIG, make sure OPTCOMPIND=0. Run the queries in dbaccess with SET EXPLAIN ON. >John DeSilva >MCS Limited >jads@mcs.bm > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care