IDS 11.5 and Physical Log Manipulation

[Keith Simmons]

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

[Art Kagel]

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.

Post by Keith Simmons
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
http://www.iiug.org/mailman/listinfo/informix-list