The HCL Informix database logs information including failed ODBC login attempts to the server database log file.
The default location of the database log file is found at: /opt/informix/cmsids.log
CMS provides the following ODBC and JDBC encryption logging:
High-level logging (such as start, fail, or complete) is provided in the following log file:
/cms/install/logdir/admin.log
Detailed logging for all primary activities and errors is provided in the following log file:
/cms/install/logdir/security/cms_sec.log
To obtain the current HCL Informix IDS software version, perform the following steps while logged into the CMS server with an appropriately privileged user ID. For more information, see Providing secure access to the CMS database.
Set the environment: . /opt/informix/bin/setenv
View the current HCL Informix IDS version: onstat -
To monitor the active database sessions, perform the following steps while logged into the
CMS server with an appropriately privileged user ID. For more information, see
Providing secure access to the CMS database.
Set the environment: . /opt/informix/bin/setenv
View active database sessions: onstat -g ses
View the active sql statements: onstat -g sql
