2. Using Ingres Commands : infodb Command—Display Database Information : Infodb Command Output – Checkpoint History for Dump Section
 
Share this page                  
Infodb Command Output – Checkpoint History for Dump Section
The following is sample output from the checkpoint history for dump section:
----Checkpoint History for Dump------------------------------------------
    Date                Ckp_sequence  First_dmp  Last_dmp valid  mode
    ---------------------------------------------------------------------
    11-NOV-2015 13:58:52.65        2          1         1     1  ONLINE 
    11-NOV-2015 13:58:52.65        3          1         1     1  ONLINE,
                                                                 TABLE
Fields are as follows:
Date
Indicates the date and time the checkpoint operation was done.
Ckp_sequence
Indicates the sequence number of the checkpoint.
First_dmp
Indicates the dump sequence number of the first (or oldest) dump file corresponding to the checkpoint.
Last_dmp
Indicates the dump sequence number of the last (or youngest) dump file corresponding to the checkpoint.
Valid
Indicates whether the checkpoint is valid (1 implies valid, 0 implies invalid).
Mode
Indicates whether the checkpoint operation was online or offline (should always be online). Also indicates TABLE if the checkpoint was a table checkpoint.