Routine debugger

The routine debugger enables you to detect and diagnose errors in SQL, Java™, and PL/SQL routines that are running on a local or remote database server. With the debugger, you can control the execution of your code by setting line and variable breakpoints, suspending execution, stepping through your code, and examining the contents of variables.

The routine debugger supports debugging on Windows, Linux, and UNIX. On these platforms, the following databases and versions are supported:

Table 1.
Database server Debugging is supported for the following stored procedures and user-defined functions (routines)
DB2® Version 9.1 and 9.5 for Linux, UNIX, and Windows, using the IBM® DB2 Driver for JDBC and SQLJ SQL and Java stored procedures
DB2 Version 9.7 for Linux, UNIX, and Windows Java stored procedures, SQL routines and PL/SQL routines
DB2 for z/OS® Version 8, (with APAR PK1057 applied) SQL routines
DB2 for z/OS Version 9 SQL and Java stored procedures
DB2 for z/OS Version 10 Java stored procedures and SQL routines
Informix® Dynamic Server v11.70 SPL routines

Feedback