Oninit cdi / Archive
Talk to an expert →

If there were no onstat...

Posted in 2008

Topics: Logging & Checkpoints

MIKE MAGIE — — source: IIUG Forums & Mailing Lists

IDS v10.00.UC8 Solaris 8 6-1, 175 Bats: Left Throws: Right Born: 11/17/1967 in Independence, MO. Pretend there was no onstat -x (or any onstat) to get info about open transactions. You wanted to find out if there were any open transactions in a logical log file older than the current logical log file. Would you be satisfied with this? database sysmaster; select count(*) from systrans where tx_loguniq != 0 and tx_loguniq < (select tx_loguniq from systrans where tx_id = 1) This was hastily prepared but it seems okay to me. But I'm just a caveman, you're elaborate structured query language frightens and confuses me. MM

↪ replying to MIKE MAGIE
Obnoxio The Clown — — source: IIUG Forums & Mailing Lists

MIKE MAGIE wrote: > But I'm just a caveman, > you're elaborate structured query language frightens and confuses me. > > I am elaborate structured query language? -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com

↪ replying to Obnoxio The Clown
MIKE MAGIE — — source: IIUG Forums & Mailing Lists

Noonan! I hate when I screw up a contraction... Think the title was also bumbled... should read If there was no onstat. MM

↪ replying to MIKE MAGIE
MIKE MAGIE — — source: IIUG Forums & Mailing Lists

Actually the title is correct - subjunctive case rules.

↪ replying to MIKE MAGIE
Obnoxio The Clown — — source: IIUG Forums & Mailing Lists

MIKE MAGIE wrote: > Actually the title is correct - subjunctive case rules. > I didn't want to come across a pedant. :o) -- Cheers, Obnoxio the Clown http://obotheclown.blogspot.com

Related threads

Glossary