Re: Freed logical log files Online 7.13 UC3

->How can I be sure that a logical log file with U-B- flags does ->not contain a non commited transaction ? I understand that the 'B' indicates the logfile has been backed up to tape and is available for re-use (i.e. free). A logfile will not be backed up to tape until all transactions within it have been committed - therefore if it is flagged 'U-B' it always means all transactions have been committed and saved to tape. The only reason Informix changed from the old status (which I forget - say 'Free') to 'U-B-' was to assist them if they need to login and recover the system - by not deleting the contents of logfiles even after they have been saved to tape Informix can get an idea of what has occurred on your system recently... this is what Informix told me when I first moved from v5 to v7 and asked the same question? Kind Regards Paul Redman (75052.1341@compuserve.com OR jredman@compuserve.com)