Re: Upgrading from Informix 5.x to 7.x and AIX 3.x to 4.x

CSC CIS wrote: > > Hi All > > My client is planning to upgrade from AIX 3.x to 4.x and simultaneously = > from Informix 5.x to 7.x. The database is about 1GB and currently split = > across 4 disks. The system is an OLTP type of system, running on = > Informix 5.x and AIX 3.x. Currently the database resides on a server and = > is accessed from a client machine using Informix-Star. > > I was wondering if anybody has done something similar before and what = > are the things I need to watch out for in terms of compatibility and = > performance. > > Any help/info/pointers would be appreciated. If you want more = > information, I would be happy to find out more and let you know. > > TIA > > Sujit Pal From my experience I would say to be prepared for it to run like a dog at first. Then after it's fine tuned it's nice. Upgrade to 7.21 because 7.20 has too many bugs (I'm on 7.11 waiting for 7.22, 7.21 has a bug with DR). The things that you should look at is buffers. Once you're comfortable with that take a look at LRU_MAX_DIRTY and LRU_MIN_DIRTY (I have them set at 7 amd 5). The multiprocessor parameter, the general concept is only set it to 1 if you have at least 4 cpu's. Play with this one. There are some other things you can do but these are the ones that I remember off of the top of my head.