ODBC diagnostic trace commands

Use an ODBC diagnostic trace command to start and stop traces, query the status of a trace, capture the trace table, and format the trace information. Use the ODBC diagnostic trace only under the direction of IBM® Software Support.

The following trace commands perform the same tracing tasks and use identical syntax:
DSNAOTRC
Use this trace command for non-XPLINK ODBC applications.
DSNAOTRX
Use this trace command for 31-bit XPLINK ODBC applications.
DSNAO64T
Use this trace command for 64-bit ODBC applications.
These trace commands perform the following tracing tasks:
  • Manually start or stop the recording of memory resident diagnostic trace records.
  • Query the current status of the diagnostic trace.
  • Capture the memory resident trace table to a z/OS® data set or a z/OS UNIX environment HFS file.
  • Format the Db2 ODBC diagnostic trace.

DSNAOTRC, DSNAOTRX, and DSNAO64T syntax

Read syntax diagramSkip visual syntax diagramDSNAOTRCDSNAOTRXDSNAO64TON -L buffer size -I buffer size -M maskOFFINFDMPtrace data set specFMTinput data set specoutput data set specFLWinput data set specoutput data set spec

DSNAOTRC, DSNAOTRX, and DSNAO64T option descriptions

ON
Start the Db2 ODBC diagnostic trace.
-L buffer size
L = Last. The trace wraps; it captures the last, most current trace records.

buffer size is the number of bytes to allocate for the trace buffer. This value is required. The buffer size is rounded to a multiple of 65536 (64K).

-I buffer size
I = Initial. The trace does not wrap; it captures the initial trace records.

buffer size is the number of bytes to allocate for the trace buffer. This value is required. The buffer size is rounded to a multiple of 65536 (64K).

OFF
Stop the Db2 ODBC diagnostic trace.
INF
Display information about the currently active Db2 ODBC diagnostic trace.
DMP
Dump the currently active Db2 ODBC diagnostic trace.
trace data set spec
Specifies the z/OS data set or the z/OS UNIX environment HFS file to which Db2 writes the raw Db2 ODBC diagnostic trace data. The data set specification can be either a z/OS data set name, a z/OS UNIX environment HFS file name, or a currently allocated JCL DD statement name.
FMT
Generate a formatted detail report of the Db2 ODBC diagnostic trace contents.

Trace data captured through DSNAO64T must be formatted with the DSNAO64T command. Otherwise, trace data can become corrupted.

FLW
Generate a formatted flow report of the Db2 ODBC diagnostic trace contents.
input data set spec
DSNAO64T The data set that contains the raw Db2 ODBC diagnostic trace data to be formatted. This data set was generated as the result of a DSNAOTRC DMP command, the DSNAOTRX DMP command, or the DSNAO64T DMP command or by the DSNAOTRC DD statement when the DIAGTRACE initialization keyword enables tracing. The data set specification can be either a z/OS data set name, a z/OS UNIX environment HFS file name, or a currently allocated JCL DD statement name. If this parameter is not specified, the DSNAOTRC, DSNAOTRX, or DSNAO64T command attempts to format the memory resident DSNAOTRC that is currently active.
output data set spec
The data set to which the formatted Db2 ODBC diagnostic trace records are written. The data set specification can be either a z/OS data set name, a z/OS UNIX environment HFS file name, or a currently allocated JCL DD statement name. If you specify a z/OS data set or a z/OS UNIX environment HFS file that does not exist, Db2 allocates it dynamically. If this parameter is not specified, the output is written to standard output ("STDOUT").