Object documentationLOGSTATISTICS Locate this document in the navigation structure

 

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.

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(10)

Size of the log queue (KB)

More Information

Evaluating System Tables, LOGSTATISTICS

Concepts of the Database System, How Databases Log Data Changes