Displays status information for before-image logging.
PROMON BI Log Status display
The following shows a sample BI Log Status display.
09/25/16 Status:BI Log
16:23
Before-image cluster age time: 60 seconds
Before-image block size: 8192 bytes
Before-image cluster size: 512 kb (524288 bytes)
Number of before-image extents: 1
Before-image log size (kb): 2168
Bytes free in current cluster: 521177 (100%)
Last checkpoint was at: 09/25/16 13:56
Number of BI buffers: 5
Full buffers: 0
Current BI Cluster: 4
BI Cluster HWM: 4
The display contains the following fields:
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 buffers on disk. When this occurs, the transaction is durably recorded on disk.
Before-image block size — The BI block size.
Before-image cluster size — The BI cluster size.
Number of before-image extents — The number of BI files.
Before-image log size (kb) — The size of the BI log file, in kilobytes.
Bytes free in current cluster — The number of free bytes remaining in the current BI cluster.
Last checkpoint was at — The time of the last checkpoint.
Number of BI buffers — The number of BI buffers.
Full buffers — The number of full BI buffers.
Current BI Cluster — The number of the current BI cluster.
BI Cluster HWM — The high water mark of the BI clusters.