Re: Removing Logical Logs

Art S. Kagel wrote: > 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. Today must be my day for nit-picking... The logs that contain *current* transaction data can be found by running onstat -x and looking in the "log begin" column. (I'm sure there's an equivalent SMI query, but don't know it off the top of my head.) It's true that you cannot drop the log containing the last checkpoint, or any log after it, because of recovery, but even if you use onmode -c to force a checkpoint in the current log, you will still be unable to drop any logs between the earliest one in the "log begin" column and the current one, because they are needed for rollback. June -- june_t@hotmail.com Grounded in Palo Alto, living on M&M's (plain)