Preparing to debug

When deploying a stored procedure for debug, you must enable debugging and set the session manager preferences.

When deploying SQL stored procedures, you enable debug by selecting the Enable debugging check box in the Routine Options page of the Deploy Routines wizard.

When deploying Java™ stored procedures, you enable debug by entering -g in the Compile options field in the Routine Options page of the Deploy Routines wizard.

Before you can debug SQL or Java stored procedures, you must set the session manager preferences in the stored procedure debug preferences. For information about this, see the related topic.

Related tasks
Setting stored procedure debug preferences
Setting up the LUW server for debugging
Preparing to debug on z/OS
Using the SQL Results view
Starting a debug session
Using the stored procedure debug launch configuration

Feedback