Informix v7.24 on HP-UX 10.20
We've recently upgraded to this version and had a lot of problems with it. I've posted pleas for help on some of these problems. We seem to have got to the bottom of them now, so may I share my experiences? I would point out that, as far as I know, these problems are specific to HP-UX: Originally we found that IDS would hang after a few minutes' operation. This problem was eventually remedied (after five weeks) by HP, who suggested, inter alia, setting RESIDENT=1. We've had no further hanging problems. Once we did go live we found that we had greatly reduced performance. This was most noticeable (in reality probably most measurable) in our regular batch suites and. for some reason, level 1 archives, whose elapsed times increased by a factor of three or more. Informix have now alerted me to bug warning 92132, which warns of severe I/O performance degradation using kaio on some versions of v7.2x. I have disabled kaio on our production engine and, as if by magic, the problems have gone away. So be warned! Neil Truby aracnet Limited Weybridge, UK
My problem was that the informix database seems to lock up and I have to
kill the oninit processes and cleanup shared memory. we are running 7.24.UC6
on HP-UX 10.20 I put a bug patch on from HP that helps to wake up sleep
processes PHKL_14283 that has helped a lot but it is still happining any
other suggestions.
Neil Truby wrote: > > We've recently upgraded to this version and had a lot of problems with it. > I've posted pleas for help on some of these problems. We seem to have got > to the bottom of them now, so may I share my experiences? I would point out > that, as far as I know, these problems are specific to HP-UX: > > Originally we found that IDS would hang after a few minutes' operation. > This problem was eventually remedied (after five weeks) by HP, who > suggested, inter alia, setting RESIDENT=1. We've had no further hanging > problems. > > Once we did go live we found that we had greatly reduced performance. This > was most noticeable (in reality probably most measurable) in our regular > batch suites and. for some reason, level 1 archives, whose elapsed times > increased by a factor of three or more. Informix have now alerted me to bug > warning 92132, which warns of severe I/O performance degradation using kaio > on some versions of v7.2x. I have disabled kaio on our production engine > and, as if by magic, the problems have gone away. > > So be warned! > > Neil Truby > aracnet Limited > Weybridge, UK Are you attempting any commands on client sides like db_access or db_to_asc? I understand that there is a problem with Informix 7 and how it deals with clients attempting to get db updates using these commands. Any info that you could provide would be helpful. Thanks! -- Jill Katrina Snider Visteon/Ford Motor Company 17000 Rotunda Dr., C275 Dearborn, MI 48121-6010 ph: 313-845-8955 fax: 313-322-9754