Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Before-image log activity (_ActBILog)
 
Before-image log activity (_ActBILog)
The _ActBILog VST displays before-image log activity, such as the number of before-image reads and writes, records and bytes written, number of records and bytes read and the number of busy and empty buffer and log force waits.
Field name
Data type
Description
_BiLog-BOBufHit
INT64
Number of input buffer hits
_BiLog-BBuffWaits
INT64
Number of times a process had to wait for a buffer that was busy.
_BiLog-BIWWrites
INT64
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.
_BiLog-BytesRead
INT64
Number of bytes of data read from the BI file.
_BiLog-BytesWrtn
INT64
Number of bytes of data written to the BI file.
_BiLog-ClstrClose
INT64
Number of BI clusters filled and closed in preparation for reuse.
_BiLog-EBuffWaits
INT64
Number of times a process had to wait because all buffers were full.
_BiLog-ForceWaits
INT64
Number of waiting-for-commit records to be written to disk.
_BiLog-ForceWrts
INT64
Number of waiting-for-commit records written to disk.
_BiLog-InputBufHit
INT64
Number of input buffer hits
_BiLog-ModBufHit
INT64
Number of modified buffer hits
_BiLog-OutputBufHit
INT64
Number of output buffer hits
_BiLog-PartialWrts
INT64
Number of writes to the BI file made before the BI buffer is full.
_BiLog-RecRead
INT64
Number of BI records (notes) read from the BI file.
_BiLog-RecWriten
INT64
Number of BI records (notes) written to the BI file.
_BiLog-TotalWrts
INT64
Number of total writes to the BI file.
_BiLog-TotReads
INT64
Number of BI blocks read from the BI file to undo transactions.
_BiLog-Trans
INT64
Number of transactions committed to the BIfile.
_BiLog-UpTime
INTEGER
Number of seconds the BI file was open.