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.
Monitoring and troubleshooting connection managementTools are available to monitor connection management, and help you diagnose potential problems.

Monitoring and troubleshooting connection management

Tools are available to monitor connection management, and help you diagnose potential problems.

The following options are available for connection management monitoring and troubleshooting:

Set the LOG and LOGFILE parameters in Connection Manager configuration files. Log files contain information about service level agreements, failover configuration, and status information. The location of the log file is displayed when the Connection Manager is started.
Run onstat -g cmsm to display information about Connection Manager instances.
Set the CMALARMPROGRAM parameter in Connection Manager configuration files, and configure the cmalarmprogram script to handle event alarms.
If the Connection Manager raises an event alarm:
- The INFORMIXCMNAME environment variable stores the name of the Connection Manager instance that raised the alarm.
- TheINFORMIXCMCONUNITNAME environment variable stores the name of the Connection Manager connection unit that raised the alarm.