Show TOC

Example documentationLOGQUEUESTATISTICS

 

Use of the system tableSYSINFO.LOGQUEUESTATISTICS

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 LOGQUEUESTATISTICS to determine the following database information, among other things:

  • ID of the log queue

    SELECT queueid

    FROM SYSINFO.LOGQUEUESTATISTICS

  • Number of wait situations due to log queue overflow

    SELECT queueoverflowcount

    FROM SYSINFO.LOGQUEUESTATISTICS