Home | Previous Page | Next Page   Logging and Log Administration > Managing the Database-Logging Mode > Monitoring the Logging Mode of a Database >

Monitoring the Logging Mode with SMI Tables

Query the sysdatabases table in the sysmaster database to determine the logging mode. This table contains a row for each database that the database server manages. The flags field indicates the logging mode 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 ]