Re: Logical logs

Patrick You can increase the NUMBER of logical log files by executing the onparams command, which will effectively increase the size of your logical log space. You need to add few more logfiles using the "onparams -a -d logDBSpace" command and increase the value of LOGSMAX in your onconfig file. Also you need to run an ontape -s (full backup) in order to make the new logfiles active. HTH Sujit patrick Blint <pb@aquila.de> on 08/04/99 02:13:17 AM Please respond to patrick Blint <pb@aquila.de> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Logical logs 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

A quick comment: Running the full level 0 backup (ontape -s) to /dev/null is an old trick we've employed to activate the log files in just a few seconds, especially if the database was already recently backed up. Email me if you need any assistance on setting your tape params to /dev/null (it's in onconfig). Sujit.Pal@bankofamerica.com wrote: > Patrick > > You can increase the NUMBER of logical log files by executing the onparams > command, which will effectively increase the size of your logical log > space. You need to add few more logfiles using the "onparams -a -d > logDBSpace" command and increase the value of LOGSMAX in your onconfig > file. Also you need to run an ontape -s (full backup) in order to make the > new logfiles active. > > HTH > Sujit > > patrick Blint <pb@aquila.de> on 08/04/99 02:13:17 AM > > Please respond to patrick Blint <pb@aquila.de> > > To: informix-list@iiug.org > cc: (bcc: Sujit Pal) > Subject: Logical logs > > 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 -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com