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™.
High availability and scalabilityA successful production environment requires database systems that are always available, with minimal if any planned outages, and that can be scaled quickly and easily as business requirements change.
Connection management through the Connection ManagerConnection Managers can control automatic failover for high-availability clusters, monitor client connections and direct requests to appropriate database servers, act as proxy servers and handle client/server communication, and prioritize connections between application servers and the primary server of a high-availability cluster. Connection Managers support high-availability clusters, replicate sets, server sets, and grids.
Configuring connection managementTo configure connection management, you must install software, set environments and connectivity information, create Connection Manager configuration files, and run the oncmsm utility.
Creating Connection Manager configuration files
Parameters and format of the Connection Manager configuration fileThe following example shows the format of the Connection Manager configuration file, and shows which parameters and attributes can be set for each connection-unit type.
LOG Connection Manager configuration parameterThe LOG parameter specifies logging for Connection Manager modes.

LOG Connection Manager configuration parameter

The LOG parameter specifies logging for Connection Manager modes.

Syntax

Table 1. Values for the LOG Connection Manager configuration parameter
LOG parameter value	Description
`0` (default)	Specifies that logging is turned off.
`1`	The Connection Manager logs proxy-mode and redirect-mode SLA information.
`2`	The Connection Manager logs proxy-mode SLA information only. Data send-and-receive activities between clients and the Connection Manager is logged.
`3`	The Connection Manager logs proxy-mode SLA information only. Data content between clients and the Connection Manager is logged.

Usage

The LOG parameter is optional, and applies to the following connection units:

CLUSTER
GRID
REPLSET
SERVERSET

Set the LOGFILE parameter to specify where log files are stored. If the LOGFILE parameter is not set, the Connection Manager creates a log file in the $INFORMIXDIR/tmp directory, with a name of connection_manager_name.process_ID.log.

Example

In the following example, the Connection Manager logs proxy-mode and redirect-mode SLA information to $INFORMIXDIR/tmp/my_cm.log.

LOG 1
LOGFILE $INFORMIXDIR/tmp/my_cm.log