|
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 |
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.