DEBUG Connection Manager configuration parameter

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

Syntax
Read syntax diagramSkip visual syntax diagramDEBUG 01
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