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.