Re: Removing Logical Logs

jlsmith269@my-dejanews.com wrote: > > Hi, > > I have Informix version 7.3. We have recently migrated our app to informix. > I want to remove some logical logs that are sitting in my rootdbs. When I > try the onparams -d -l 1, I get "can only drop an unused logical log.". I > dont understand how to make a logical log free again. > > I am also looking for some advice on logical log size. I have searched the > news groups and havent found a clear answer on the subject. You can remove any logical log that has only the flags 'U-B----' except those between the log showing a 'C' in the flags and the one showing an 'L' in the flags (these may be the same log file or a different one). These logs have current transaction data needed for recovery so they cannot be dropped. You can mark the uneeded logs as backed up by running ontape -a. Also the log number you pass to onparams to drop a log is its ordinal log number from column 2 of the onstat -l report not the unique id from column 4. I use 76 - 100MB log files for our servers but you will need to size them according to your own needs. My article in the latest Informix Tech Notes (available online) gives some guidelines. Art S. Kagel