Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Administrator's GuideThe HCL OneDB™ Administrator's Guide provides the information required to administer HCL OneDB™.
Logging and log administration
Manage the database-logging modeYou can monitor and modify the database-logging mode.
Monitor the logging mode of a database
Monitor the logging mode with SMI tables

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 OneDB™ Administrator's Reference.