Re: IDS 11.5 and Physical Log Manipulation

You cannot change the physical log size using any parameter in the ONCONFIG file. You have to run onparams: onparams -p -s <newsize> [-d dbspacename] -y the -d parameter is optional if you have enough room in the current dbspace containing the physical log for the existing log and the new log to exist simultaneously for a few seconds until the new one has been initialized and made active. If you only have space there for the new log, run onparams twice. Once to move the physical log to a rather small one in rootdbs then again to move it to its final location and size. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jan 23, 2013 at 11:23 AM, Keith Simmons <smiley73@gmail.com> wrote: > Hi All > > Can someone clarify for me please. > I have an IDS11.5 engine running on Solaris and have hit a performance > issue. I > have narrowed it down to the size of the physical log, at certain times it > is getting > filled very quickly and initiating checkpoints (every 30 seconds) these > are also too > long but that is another issue. > I've tried to change the size of the physlog by editing the onconfig file > and > bouncing the engine, but , although the online log seems to indicate this > was > successful, onstat -l, onstat -g ckp and the checkpoint intervals clearly > indicate > this is not so (I also tried to increase the physlog buffer size and > loglog buffer size > but these do not seem to have taken effect). I also have doubts about > where the > physlog is located (which dbspace). > What is the correct way to relocate, resize and change the buffer size for > the > physical log on an 11.5 engine, and can it be done with impunity with the > engine > running or does it require a bounce ? > > Many Thanks > > Keith > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >