Filter
Top Products
3-62 IBM Informix OnLine Database Server Administrator’s Guide
Monitor Archive History
From the Command Line
From the command line, execute tbcheck -pr to display root dbspace
reserved page information. The last pair of reserved pages contains the
following information for the most recent archive:
■ Archive level (0, 1, or 2)
■ Effective date and time of the archive
■ Time stamp describing when the archive began (expressed as a
decimal)
■ ID number of the logical log that was current when the archive began
■ Physical location in the logical log of the checkpoint record (that was
written when the archive began)
The effective date and time of the archive are the date and time of the check-
point that this archive took as its starting point.
For example, if no one had accessed OnLine since Tuesday at 7 p.m. and you
create an archive on Wednesday morning, the effective date and time for that
archive would be Tuesday night, reflecting the time of the last checkpoint.
(No checkpoints are performed if activity is zero.)
Refer to page 2-102 for further information about the fields related to
archiving that appear in the reserved page display.