Re: Hung Server

Art S. Kagel wrote: > Chris S wrote: > >> We've recently been having a very strange issue with one of our >> Informix Servers. It's IDS 7.31UD1 running on AIX 4.3.3. The server >> appears to go into a vegetative state and is no longer controllable >> through normal means. > > <SNIP> > > Upgrade. 7.31UD1 is ancient and relatively buggy. The latest is UD8 IB > and an upgrade to 10.00xC4 would be beneficial in performance and > features and more stable. > > Art S. Kagel > On what basis is the IDS server to blame here? One could just as easily write "AIX 4.3.3 is ancient and relatively buggy". How many shared memory segments have you got? What does onstat -g act show? ipcs -ma and ps -aldef (not sure on AIX if this works may give a few clues. Try dumping out shared memory using onstat -o, then "kill off the server"; you can then use onstat against the shared memory dump to see if there was anything strange going on. What about the O/S ... how much RAM is there - is it still all there? How much memory do you run this instance in? Anything else using loads of shared memory?

"TBP" <TheBigPotato@NotHere.Co.Uk> wrote in message news:8PRDf.93$Dn4.2@newsfe3-gui.ntli.net... > Art S. Kagel wrote: >> Chris S wrote: >> >> Upgrade. 7.31UD1 is ancient and relatively buggy. The latest is UD8 IB >> and an upgrade to 10.00xC4 would be beneficial in performance and >> features and more stable. >> >> Art S. Kagel >> > > On what basis is the IDS server to blame here? One could just as easily > write "AIX 4.3.3 is ancient and relatively buggy". I do often wonder about the "upgrade" logic. It's often used by Tech Support functions, including IBM's Informix ones. I can understand why the vendor wants to limit the number of versions to support, and of course that the R&D cash is inevitably put into the most recent versions. But just because the OS and database versions are old doesn't necessarily mean they caused the problem. Stuff that worked before doesn't necessarily stop working because the versions are old: old software does not deteriorate with age like flesh and blood! "You're more likely to get this fixed if you upgrade" is probably the advice that really needs to be given.