Example documentationLOGSTATISTICS Locate this document in the navigation structure

 

Use of the system table SYSINFO.LOGSTATISTICS

Prerequisites

You can use the DEMODB demo database. Start the Database Studio and log onto the demo database DEMODB an: Logging On to a Database.

Activities

You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview

Note the General Instructions for formulating SQL statements.

You can use the system table LOGSTATISTICS to determine the following database information, among other things:

  • Size of the log area and used log area

    SELECT usablesize, usedsize, usedsizepercentage

    FROM SYSINFO.LOGSTATISTICS

  • Number of log queues and their size(s)

    SELECT queuecount, queuesize

    FROM SYSINFO.LOGSTATISTICS

  • Size of the log area that has not yet been backed up

    SELECT notsavedsize, notsavedpercentage

    FROM SYSINFO.LOGSTATISTICS