2. Using Ingres Commands : infodb Command—Display Database Information : Infodb Command Output – Cluster Journal History Section
 
Share this page                  
Infodb Command Output – Cluster Journal History Section
The following is sample output from the cluster journal history section:
----Cluster Journal History--------------------------------------------
    Node ID   Current Journal   Current Block   Last Log Address
    ------------------------------------------------------------
          0                 1               1   <760829462:4731:1592>
          1                 3              10   <760829464:35000:188>
Fields are as follows:
Node ID
Indicates the integer identifier of the node.
Current journal
Indicates the node’s current journal file sequence number.
Current block
Indicates the node’s current journal file block sequence number. This is the logical end-of-file of the node’s current journal file.
Last log address
Indicates the log address (log sequence number, log page number, log word offset) of the last log record written to a journal file on this node.