Re: How do You know when LL is free

rungashi wrote: > >In Article<5ddkfg$bjj@cssun.mathcs.emory.edu>, ><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. > The "B" indicates that it is backed up and is free. About > the only time you see an "F" is when you add new logical > logs until they are used for the first time. 'B' does not mean it is free - there may still be a transaction spanning it. All the B means is that it has been backed up. 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. YIKES! If someone out there has it, please post it. (Is this in the Informix FAQ? It sure belongs there!) -- -- Jake (Lost in thought and won't ask for directions) . . _..-'( )`-.._ ./'. '||\\\\. }\\_/{ .//||` .`\\. ./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\. ./'..|'.|| |||||\\`````` \\,@,/ ''''''/||||| ||.`|..`\\. ./'.||'.|||| ||||||||||||. ||| .|||||||||||| ||||.`||.`\\. /'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\ '.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.` '.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.` |/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\| V V V }' `\\ /' `{ V V V \\ \\ \\ V / / / +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+