Stored procedure debugger

The DB2® stored procedure debugger enables you to detect and diagnose errors in SQL and Java stored procedures that are running on a local or remote DB2 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 DB2 stored procedure debugger supports debugging on Windows, Linux, Unix, and iSeries®. On these platforms, the following levels of DB2 are supported:

Table 1.
Database server Debugging is supported for the following stored procedures
DB2 UDB for Linux, UNIX, and Windows Version 8 (with FixPak 15 installed) using the Universal Driver and local session manager SQL stored procedures
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 V5R4 on iSeries SQL and Java stored procedures
DB2 UDB for z/OS® Version 8, (with APAR PK1057 applied) SQL stored procedures
DB2 UDB for z/OS Version 9 SQL and Java stored procedures

In addition, the DB2 Application Development Tools must be installed. On Windows, the Application Development Tools are typically installed by default - on Linux, they typically need to be manually installed.


Feedback