Was this helpful?
Log Database Display Screen
The Log Database Display screen appears when you select Databases from the Log Info Menu screen.
This screen can be used to monitor logging activity by database.
The screen contains an entry for each active database. Information includes the number of transaction begins and ends, and the number of log file write requests. The status of a database can also be determined. For a list of valid status values, see Logging System Header Screen--Status Field Values.
The Log Database Display shows the following information:
DB Name
The database name.
Status
The database status. Valid values are as follows:
CKPDB_PEND
Online backup for this database is about to start.
CLOSEDB_PEND
This database is about to be closed; the last user in the database is exiting.
EBACKUP
Online backup
FAST_COMMIT
This database is running with Fast Commit.
FBACKUP
Online backup
JOURNAL
This database has journaling enabled.
NOTDB
The entry is not a database.
OPENDB_PEND
This database is about to be opened for the first user of the database.
PURGE
This database is closed and the archiver is archiving transactions.
TX Cnt
The number of currently open transactions. This is the difference between the Begin and End columns.
Begin
The number of transaction begins that have occurred so far.
End
The number of transaction ends that have occurred so far.
Read
The number of log file read requests that have been made so far. It is unusual for this value to be greater than 0 for any entry except the $recovery entry. Log file reads are usually done during transaction rollout and during journaling by the archiver.
Write
The number of log file write requests made.
Last modified date: 01/30/2023