DB2 10.5 for Linux, UNIX, and Windows

db2dumpSQLCodes IBM data server driver configuration keyword

Specifies whether diagnostic logs are gathered when specified SQLCODEs are encountered in a connection to the DB2® for z/OS® server.

Equivalent CLI keyword

Not available.

Equivalent IBM® data server provider for .NET connection string keyword

Not available.

IBM data server driver configuration file (db2dsdriver.cfg) syntax

<parameter name="db2dumpSQLCodes" value="'DEFAULT' | 'OFF' | Absolute SQLCODE1 value, Absolute SQLCODE2 value, ..."/>

Default setting:

The default value is 'OFF'.

Usage notes:

You can enable a mechanism to capture diagnostic information on the first occurrence of an SQL error event in the connection to the DB2 for z/OS server with the db2dumpSQLCodes keyword. When you set the db2dumpSQLCodes keyword to a 'DEFAULT' or list of SQLCODEs, the following diagnostic information is written to a log file on the occurrence of a specified SQLCODE event.

Sysplex configuration information
Sysplex member statistics
Sysplex group statistics
Connection details that include the connection state and the process state
Client information properties that are explicitly set¹

Two rotating diagnostic log files that are 1 MB are generated per each application process. The name of the diagnostic log file consists of the db2dumpdata_<pid>.<index>.log format. The <pid> value in the log file name represents the process ID of the application and the <index> value represents a value that is equal or greater than 0. Once the log file reaches the size of 1 MB, log file with the smallest index value is deleted, and new log file is created.

The diagnostic log files are placed in the clientrecords subdirectory under the diagnostic data directory path (diagpath).

You must ensure that the diagnostic log files in the clientrecords subdirectory are deleted regularly to free up disk space on your system.

The db2dumpSQLCodes keyword setting takes effect only after the application is restarted.

'DEFAULT'

A special value that is equivalent to setting the following absolute SQLCODE values.

30108 for the SQL30108N error
20542 for the SQL20542N error
1224 for the SQL1224N error

'OFF'

No diagnostic information is logged.

Absolute SQLCODE values

Absolute SQLCODE values that are separated by comma. Only the absolute SQLCODE values can be specified. The following sample IBM data server driver configuration file entry lists SQL30108N and SQL20542N for the db2dumpSQLCodes keyword.

<parameter name=”db2dumpSQLCodes” value=”30108,20542"/>

¹ The default values of configuration parameters are not logged.