Re: memory increase

Anderson Deluiz wrote: > Hi all, > > I'm not an Informix DBA but I want to check if what our DBA told me > about configuration on Informix after increasing memory on our AIX > 4.3.3 box is true. The version of Informix is 7.31UC4, I think. > > Is that true that after adding physical memory to the machine, we > don't have to change anything in Informix config files to use this > newly added memory ? No. It depends where you want to use the memory, but in general the first thing you would do is increase your BUFFERS. The database server will not do this automatically and you will need to bounce the database server after changing configuration parameters. > We added more 1GB in our box and he told me that Informix reconfigures > itself automatically. No. You need some tuning effort there. > I thought it were strange because if you are > running more instances in this machine, how Informix knows the > quantity of memory they need separately ? It can affect performance, > since the bigger instance may have less memory. Exactly. > Sorry for my english and thanks for your help. Sorry for my help, thanks for your English. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+