Progress
Database Administration
Guide and Reference
Activity Displays>BI Log
Displays information about BI Log Activity. Figure A–25 shows a sample BI Log Activity display.
Figure A–25: PROMON BI Log Activity Display
The display lists the following types of BI operations:
- Total BI writes — The number of writes to the BI file.
- BIW BI writes — The number of writes to the BI file performed by the before-image writer (BIW). For good performance, this number should be high in relation to the total number of BI writes.
- Records written — The number of BI records (notes) written to the BI file.
- Bytes written — The amount of data written to the BI file, in bytes.
- Total BI Reads — The number of BI blocks read from the BI file (to undo transactions).
- Records read — The number of BI records (notes) read from the BI file.
- Bytes read — The amount of data read from the BI file, in bytes.
- Clusters closed — The number of BI clusters filled and closed in preparation for reuse.
- Busy buffer waits — The number of times a process had to wait for someone else to finish before being able to write to a BI file.
- Empty buffer waits — The number of times a process had to wait because all buffers were full.
- Log force waits — The number of waiting-for-commit records to be written to disk.
- Partial Writes — The number of writes to the BI file made before the BI buffer is full. This might happen if:
- The Delayed BI File Write (-
Mf
) parameter timer expired before the buffer was filled.- An APW attempts to write a block whose changes are recorded in a BI buffer that has not been written. Because BI notes must be flushed before the AI note is flushed, the AIW writes the data in the BI buffer before the buffer is full so it can do the AI write.
- An AIW ran ahead of the BIW. Because BI notes must be flushed before the AI notes can be written, the AIW writes the BI buffer before it is full, so it can do the AI write.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |