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:
- 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
- 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