2. Using Ingres Commands : infodb Command—Display Database Information : Infodb Command Output – Journal Information Section
 
Share this page                  
Infodb Command Output – Journal Information Section
The following is sample output from the journal information section:
----Journal information-----------------------------------------------
    Checkpoint sequence :      3    Journal sequence :               3
    Current journal block :    2    Journal block size :         16384
    Initial journal size :     4    Target journal size :          512
    Last Log Address Journaled : <760829464:19666:188>
Fields are as follows:
Checkpoint sequence
Indicates the current checkpoint sequence number. Incremented when a checkpoint operation is performed.
Journal sequence
Indicates the current journal file sequence number.
Current journal block
Indicates the current journal file block sequence number. This is the logical end-of-file of the current journal file.
Journal block size
Indicates the block size of the current journal file, in bytes.
Initial journal size
Indicates the number of blocks initialized in the “first journal file” when it is created. The first journal file is the journal file created during the checkpoint +j operation. Subsequent journal files created before the next checkpoint is done will not be initialized.
Target journal size
Indicates the size, in blocks, to which the current journal file may grow before a new journal file should be created. A new journal file will be created at the start of the next archive cycle after the current journal file reaches this size.
Last log address journaled
Indicates the log address (log sequence number, log page number, log word offset) of the last log record written to a journal file.