Re: v5.05 Logical Log Backups

>One of our customers has a v5.05 database utilizing 15 10MB logical logs (I >know that they need to be increased). They do not run continious log backups >because they have the entire disk mirrored on a different site, so they >don't care about keeping the LL's on tape. They have the tape device for the >LL's set to /dev/null. > >My understanding of this was that as the logs become full, and once any work >within them is marked as complete (ie, any BEGIN WORK's have been correctly >paired with a ROLLBACK/COMMIT), the log would be cleaned and marked as free. > >What's actually happening is that the logs are sitting there and only a >tbtape -a is actually zapping them (marking them as backed up). When the log buffer becomes full, the entire buffer is eligible to be archived to tape. If you are going to set the tape device to /dev/null, you might as well turn on continuous log backups. This will cause the log buffers to be available for re-use instantly (assuming that the log space isn't being consumed by a single transaction. That's a whole different story :) ) Paul Kapp ----> PLKapp@aol.com -OR- plk@usorder.com