Display Transactions and Logs (3 of 3)

-- join data from counts with syslogs

select uniqid,

size,

is_backed_up, -- 0 = no, 1 = yes log is backed up

is_archived, -- 0 = no, 1 = yes log is on last archive

c.cnt tx_beg_cnt,

d.cnt tx_curr_cnt

from syslogs, outer c, outer D

where uniqid = c.tx_logbeg

and uniqid = d.tx_loguniq

order by uniqid

Previous slide

Next slide

Back to first slide

View graphic version