Home | Previous Page | Next Page   Logging and Log Administration > Managing Database-Logging Status > Monitoring Transaction Logging >

Monitoring Transaction Logging with SMI Tables

Query the sysdatabases table in the sysmaster database to determine the logging status. This table contains a row for each database that the database server manages. The flags field indicates the logging status of the database. The is_logging, is_buff_log, and is_ansi fields indicate whether logging is active, and whether buffered logging or ANSI-compliant logging is used. For a description of the columns in this table, see the sysdatabases section in the chapter about the sysmaster database in the IBM Informix: Administrator's Reference.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]