Re: How do You know when LL is free

>><KENDRICKS.CHERYL@heb.com> writes: >>>DB System: Informix Online 7.12 >>> >>>How do you know when a logical log is Free. In Online 7.12 I never see >>>the status of the logical log file go to "F-----". If it is "U-B----" >>>does this now mean it is free? I do remember this as being discussed >>>in this list. Even better than that, it was discussed in your documentation! Always always *always* read your release notes and machine notes. They represent the last word on what is happening, and can be much more pertinent than the printed documentation. RELEASE NOTES FOR INFORMIX 7.12.UC1 PRODUCT RELEASE DATE: 05 Dec 1995 CHANGE TO WHEN LOGICAL LOGS ARE FREED ===================================== Prior to 7.10.UD1, a logical log was marked as free for re-use once it was backed up if all other necessary conditions were met. The onstat -l output would indicate the logical log had been freed by putting an "F" in the flags column. As of 7.10.UD1, logical logs are no longer freed as soon as possible--instead logical logs are freed only just prior to re-use. One advantage of this new strategy is that the logs are available for use by onlog for a longer period of time. The disadvantage is that onstat -l no longer indicates ahead of time (by the presence of the "F" flag) that a log is available for re-use. TFM 7.1 failed to mention this change, as it came along after printing time. In the documentation for the Universal Server, this is rectified: "A logical-log file has a status of F only if the system has been reinitialized. A logical log with just the two status flags U-B (and not L) is available only if it is not spanned by an active transaction." "What Are The Status Flags of Logical Log Files" Informix-Universal Server Administrator's Guide, Vol 1 Version 9.0, December 1996 Part No. 000-3668 Interestingly, in the latest release of Workgroup Server this is not true, and the logs are freed immediately, as before. Jake replies: >I have seen an SQL script somewhere that queroes sysmaster.syslogs and >seeks all logs that have been backed up, joining with rows from >systransactions seeking the lowest log-seq beginning in any transaction >row. >If someone out there has it, please post it. (Is this in the Informix >FAQ? It sure belongs there!) How does this differ from simply reading the output of 'onstat -l' and noting the "flags" field? (In which case it is covered thoroughly in TFM, and need not clutter the FAQ.) Cheers, ______________________________________________________ Clem Akins (aka clema@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: Motorcyclin' in the glorious California sunshine