Logical logs
patrick Blint, new to Informix Dynamic Server, asked how to increase the logical log size. Aomar Bariz said an existing log cannot be enlarged, only a new one added using onparams or onmonitor. Laurent COLLIGNON pointed to LOGFILES and LOGSMAX in ONCONFIG and gave onparams -a -d <dbspace> -s <size>, with onstat -l and -d to check. Another poster said onmonitor is easiest and a restart is needed.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi Everyone , I am new to the administrative side of Informix Dynamic OL Server and would be gratefull if someone is able to give me a clear answer pertaining to increasing the size of my logical log file. I have tried adjusting the parameters in my confiuration files that did not seem to resolve the problem at all. Tried to use onparm , but the parameters in the book was confusing. My email pb@aquil.de Best Regards , Patrick Blint
Hi patrick,
you could bot increase the size of your logical log but you could only add
a new one .
you should onparams or onmonitor
Aomar
patrick Blint wrote:
> Hi Everyone ,
>
> I am new to the administrative side of Informix Dynamic OL Server and
> would be gratefull if someone is able to give me a clear answer
> pertaining to increasing the size of my logical log file.
>
> I have tried adjusting the parameters in my confiuration files that did
> not seem to resolve the problem at all.
> Tried to use onparm , but the parameters in the book was confusing.
>
> My email pb@aquil.de
>
> Best Regards ,
>
> Patrick Blint
As I can recall you have to check your ONCONFIG file where LOGFILES give
the number of log files and LOGSMAX the maximum number of log files.
After that you must add new log files with
onparams -a -d <dbspacename> -s <size>Try also onstat -l to check the actual config and onstat -d to list your
dbspaces.
patrick Blint wrote:
> Hi Everyone ,
>
> I am new to the administrative side of Informix Dynamic OL Server and
> would be gratefull if someone is able to give me a clear answer
> pertaining to increasing the size of my logical log file.
>
> I have tried adjusting the parameters in my confiuration files that did
> not seem to resolve the problem at all.
> Tried to use onparm , but the parameters in the book was confusing.
>
> My email pb@aquil.de
>
> Best Regards ,
>
> Patrick Blint
Once you adjust your parameters, you must restart the database server for these to take effect. If you are new onmonitor is probably the easiest way. Edit logfiles, then shutdown and restart the server In article <37A8042D.FFB51BCD@aquila.de>, patrick Blint <pb@aquila.de> wrote: > Hi Everyone , > > I am new to the administrative side of Informix Dynamic OL Server and > would be gratefull if someone is able to give me a clear answer > pertaining to increasing the size of my logical log file. > > I have tried adjusting the parameters in my confiuration files that did > not seem to resolve the problem at all. > Tried to use onparm , but the parameters in the book was confusing. > > My email pb@aquil.de > > Best Regards , > > Patrick Blint > > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.