3-62 IBM Informix OnLine Database Server Administrator’s Guide
Monitor Archive History
From the Command Line
From the command line, executetbcheck -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)
■IDnumber of the logical log that was current when the archive began
■Physicallocation in the logical log of the checkpoint record (that was
written when the archive began)
Theeffective date and time of the archive are the date and time of the check-
point that this archive took as its starting point.
Forexample, if no one had accessed OnLine since Tuesday at 7 p.m. and you
createan 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 topage 2-102 for further information about the fields related to
archiving that appear in the reserved page display.