Problem:

Tracing for XDB (SQL for DB2):

Resolution:

Using MFE:  In the mfuser\\config\\xdb.ini

Using Net Express:  In the mfsql\\cfg\\xdb.ini

For Client tracing, add the following new section in the xdb.ini file:

[TRACE]

RedirSndRcvTrace=c:\\redir.trc

TraceType=1

RouterTrace=c:\\router.trc

For Migrate tracing, add the following to the [TRACE] Section of the xdb.ini:

MigrateTrace=c:\\mig.log

For XDB Link tracing, add the following to the {SERVER] Section of the xdb.ini:

TRACEDRDA=1

The XDB Server must be stopped and restarted for Link tracing to be in effect.

For JDBC tracing, add the following to the [SERVER] Section of the xdb.ini:

DFTrace=c:\\df.txt

The trace can be started and stopped with the following SQL statements.  

These can be performed from SQLWizard:

START DIRECTFLIGHT TRACE;

STOP DIRECTFLIGHT TRACE;

All traces added to the xdb.ini can be commented out by adding a semi-colon (;) to the beginning of each line.