DB2 Server for VSE & VM: Interactive SQL Guide and Reference

ISQLTRACE

>>-ISQLTrace----+-DUMP----+------------------------------------>< +-DISPLAY-+ '-integer-'

The ISQLTRACE command traces activity within ISQL. This ISQL command traces calls to and returns from other ISQL modules, SQL return codes, and ISQL messages. Trace information is saved in storage for dump debugging.

DUMP

specifies that the trace information is to be printed. ISQL creates an unformatted storage dump hardcopy of the trace table.

DB2 Server for VM
ISQL uses the CP DUMP command to dump to the lowest priority virtual printer defined.

DB2 Server for VSE
ISQL issues a CICS dump to the CICS dump data set.

You must run a job to print the dump data set.

DISPLAY

specifies that the formatted trace table is to be displayed on the display. If more than 50 entries or more than the specified integer number of entries have been made in the trace table, the entries wrap. The more recent entries are written over the earlier entries. As a result, only the last 50 entries or integer number of entries in the table are displayed. The entries are displayed in reverse order of the order that they were put into the trace table.

integer

changes the size of the trace table. Replace integer with the number of trace entries that are to be contained in the trace table. integer must be a number from 50 to 1000.