Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Logging Summary

> Displays status information for the database logging function. Figure 19–23 shows a sample Logging Summary Status display.

>     09/25/03        Status: Logging Summary
>     16:22
>     Crash protection:                Yes
>     Delayed Commit:                  3 seconds
>     Before-image I/O:                Reliable
>     Before-image cluster age time:   60 seconds
>     BI Writer status:                Executing
>     Two-Phase Commit:                *** OFF ***
>     After-image journalling:           Yes
>     After-image I/O:                   Reliable
>     AI Writer status:                  Not executing

> Figure 19–23: PROMON Logging Summary Status display

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

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

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

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095