You can use the DB2 Stored Procedure Builder (SPB) to assist in the creation of Java stored procedures. The SPB is a graphical application that supports the rapid development of DB2 stored procedures. There are design assistants within the SPB to guide you through basic design patterns, to help you create SQL queries, and to estimate the performance cost of invoking a stored procedure.
Using the Debug Settings notebook in the SPB, you can view all the stored procedures that you have the authority to change, add, or remove. You can also debug entries in the stored procedures debug table. If you have DBADM authority, or if you created the selected stored procedure, you can grant authorization to other users so that they can debug the stored procedure. See the online help for more information on using the SPB to debug stored procedures.