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 Informix® database servers.
Administrator's GuideThe Informix® Administrator's Guide provides the information required to administer HCL Informix®.
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.
DEBUG Connection Manager configuration parameterThe DEBUG parameter specifies whether logging of SQL and ESQL/C error messages is enabled or disabled.

DEBUG Connection Manager configuration parameter

The DEBUG parameter specifies whether logging of SQL and ESQL/C error messages is enabled or disabled.

Syntax

Table 1. Values for the DEBUG Connection Manager configuration parameter
DEBUG parameter value	Description
`1`	Enables logging of SQL and ESQL/C error messages.
`0` (default)	Disables logging of SQL and ESQL/C error messages.

Usage

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

CLUSTER
GRID
REPLSET
SERVERSET

Debug messages are created in the location that is specified by the LOGFILE parameter in the Connection Manager configuration file. If the LOGFILE parameter is not specified, then the Connection Manager creates $INFORMIXDIR/tmp/connection_manager_name.pid.log.

Connection Manager debug logging is enabled in the configuration file; you cannot enable debug mode from the command line.

Example

In the following example, a my_log is created in $INFORMIXDIR/tmp and logging of SQL and ESQL/C error messages is enabled.

LOGFILE $INFORMIXDIR/tmp/my_log
DEBUG 1

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.