LOGSTATISTICS 
Definition
The system table 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 instance.
Structure
LOGSTATISTICS
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) |
See also:
Evaluating System Tables, LOGSTATISTICS
Concepts of the Database System, Logging Data Changes