Monitor 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 HCL Informix® Administrator's Reference.


Copyright© 2019 HCL Technologies Limited