Displays status information for the database logging function.

PROMON Logging Summary Status display

The following shows a sample Logging Summary Status display.

09/25/06        Status: Logging Summary
16:22

Crash protection:                Yes
Delayed Commit:                  3 seconds
Before-image I/O:                Reliable
Before-image cluster age time:   0
BI Writer status:                Executing
Two-Phase Commit:                *** OFF ***
After-image journalling:         Yes
After-image I/O:                 Reliable
AI Writer status:                Not executing
BI Manager status:               Executing

The display contains the following fields:

  • Crash protection — Yes, if crash protection is enabled; no, if it is not.
  • Delayed Commit — The current value of the Delayed BI File Write (-Mf) parameter.
  • Before-image I/O — One of the following values:
    • Reliable if synchronous or direct I/O is being used for BI writes
    • BUFFERED if buffered I/O is being used for BI writes. Buffered I/O is not recommended
  • Before-image cluster age time — The period of time that must pass before a BI cluster is reused. This period ensures that database blocks flushed at checkpoint are moved from the UNIX buffers on disk. When this occurs, the transaction is recorded on disk.
  • BI Writer status — Executing, if a BIW is running.
  • Two-Phase Commit — ON, if two-phase commit is enabled; OFF, if it is not.
  • After-image journalling — ON, if after-imaging is enabled; OFF, if it is not.
  • After-image I/O — One of the following values:
    • Reliable if synchronous or direct I/O is being used for AI writes
    • BUFFERED if buffered I/O is being used for AI writes. Buffered I/O is not recommended
  • AI Writer status — Executing, if an AIW is running.
  • BI Manager status — Executing, if a before-image manager (BIM) is running.