The system table SYSINFO.LOGSTATISTICS describes the degree to which log management is being utilized and the number of special events that have occurred during logging since the start of the database.
USABLESIZE |
FIXED(20) |
Size of the log area (KB) |
USEDSIZE |
FIXED(20) |
Used log area (KB) |
USEDSIZEPERCENTAGE |
FIXED(3) |
Used log area (%) |
NOTSAVEDSIZE |
FIXED(20) |
Size of log area not yet saved (KB) |
NOTSAVEDPERCENTAGE |
FIXED(3) |
Size of log area not yet saved (%) |
SAVEPOINTCOUNT |
FIXED(10) |
Number of savepoints |
TRANSACTIONCOUNT |
FIXED(10) |
Number of transactions |
WRITETRANSACTIONCOUNT |
FIXED(10) |
Number of write transactions |
MAXUSEDSESSIONID |
FIXED(10) |
Highest database session ID assigned |
MAXUSEDTRANSACTIONNUMBER |
FIXED(15) |
Highest transaction ID assigned |
QUEUECOUNT |
FIXED(5) |
Number of log queues |
QUEUESIZE |
FIXED(5) |
Size of the log queue (KB) |
Evaluating System Tables, LOGSTATISTICS
Concepts of the Database System, How Databases Log Data Changes