Enabling tracing for the Routine debugger on the client

If the Routine debugger does not work as expected, you can enable tracing at the workbench client.

About this task

When you use the Routine debugger, you can enable tracing to diagnose problems on the client.

Procedure

To enable the trace for the PL/SQL Routine debugger:

  1. Edit the dir_name/spdtrace.txt file to ensure that it has the following options set:

    For DB2® SQL, Java™, PL/SQL routines, and Informix® SPL routines:

    com.ibm.debug.spd/debug=true
    com.ibm.debug.spd/debug/logging=true
    com.ibm.debug.spd/debug/events=true
    com.ibm.debug.spd.sql/debug=true
    com.ibm.debug.spd.sql/debug/logging=true
    com.ibm.debug.spd.sql/debug/events=true
    com.ibm.debug.spd.java/debug=true
    com.ibm.debug.spd.java/debug/logging=true
    com.ibm.debug.spd.java/debug/events=true
    com.ibm.debug.spd.plsql/debug=true
    com.ibm.debug.spd.plsql/debug/logging=true
    com.ibm.debug.spd.plsql/debug/events=true
    com.ibm.debug.spd.spl/debug=true
    com.ibm.debug.spd.spl/debug/logging=true
    com.ibm.debug.spd.spl/debug/events=true
  2. Start the workbench with the following command and options:
    eclipse -debug file:c:/dir_name/spdtrace.txt

Results

The debug information will be written to the workspace log file, in the following location: Yourworkspace\.metadata\.log

Feedback