2. Using Ingres Commands : infodb Command—Display Database Information : Infodb Command Output – Dump Information Section
 
Share this page                  
Infodb Command Output – Dump Information Section
The following is sample output from the dump information section:
----Dump information----------------------------------------------------
    Checkpoint sequence :      3    Dump sequence :                1
    Current dump block :       1    Dump block size :          16384
    Initial dump size :        4    Target dump size :           512
    Last Log Address Dumped : <760829464::21100:100>
Fields are as follows:
Checkpoint sequence
Indicates the current checkpoint sequence number. Incremented when a checkpoint operation is performed.
Dump sequence
Indicates the current dump file sequence number.
Current dump block
Indicates the current dump file block sequence number. This is the logical end-of-file of the current dump file.
Dump block size
Indicates the block size of the current dump file, in bytes.
Initial dump size
Indicates the initial allocation of the current dump file, in blocks. The number of blocks initialized when a dump file is created.
Target dump size
Indicates the size, in blocks, to which the current dump file may grow before a new dump file should be created. A new dump file will be created at the start of the next archive cycle after the current dump file reaches this size.
Last log address dumped
Indicates the log address (log sequence number, log page number, log word offset) of the last log record written to a dump file.