Show TOC

Example documentationLOGSTATISTICS

 

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: 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