2. Using Ingres Commands : infodb Command—Display Database Information : Infodb Command Output – Checkpoint History for Journal Section
 
Share this page                  
Infodb Command Output – Checkpoint History for Journal Section
The following is sample output from the checkpoint history for journal section:
----Checkpoint History for Journal--------------------------------------
    Date                 Ckp_sequence  First_jnl  Last_jnl valid  mode
    --------------------------------------------------------------------
    11-NOV-2015 13:23:43.57         1          1         1     1  OFFLINE
    11-NOV-2015 13:24:50.40         2          2         2     1  ONLINE
    11-NOV-2015 13:58:52.65         3          3         3     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_jnl
Indicates the journal sequence number of the first (or oldest) journal file corresponding to the checkpoint.
Last_jnl
Indicates the journal sequence number of the last (or youngest) journal 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. Also indicates TABLE if the checkpoint was a table checkpoint.
To recover the entire database, you must specify #c2, for example, in the rollforwarddb command to roll forward from the database checkpoint. Checkpoint 3 was taken on selected tables.