Re: How do You know when LL is free

KENDRICKS.CHERYL@heb.com wrote: > > 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. > > Please respond to this list or vnibs2@heb.com > > Thanks > Cheryl Kendricks Hi Cheryl! Prior to 7.10.UD1 version of DSA a logical log was marked as free for RE-USE once it was backed up. The onstat -l would indicate the FREE state by displaying a flag "F" in the respective column. The New strategy (As of 7.10.UD1) is to not free a logical log as soon as possible, instead, they are freed JUST prior to RE-USE. The OnLog will benefit from this strategy because the logs will be available to it for longer period of time. The disadvantage is that onstat -l will no longer indicate ahead of time that a log is available for RE-USE. Regards, ------------------------------------------- Mario Estrada | SISTECO, S.A. Informix Support | Phone (502) 3340214 Department | Fax (502) 3348447 ------------------------------------------- Informix Certified Professional Database Specialist & System Administrator ===========================================