When you select a procedure from the contents pane and select Show Related for that object, the Show Related dialog lists any objects with first-level dependencies on that procedure. The object can be collections. You can view second-level dependencies by selecting Show Related for each object with a first-level dependency.
When a procedure is directly or indirectly dropped, all privileges on the procedure are also dropped. In addition, any plans or packages that are dependent on the procedure are made inoperative.
If a procedure is dropped using the Drop pop-up menu choice from a procedure object, the procedure is removed only from DB2 for OS/390 Version 5 catalog table SYSIBM.SYSPROCEDURES or from DB2 for OS/390 Version 6 catalog table SYSIBM.SYSROUTINES. The procedure source in catalog table SYSIBM.SYSPSM and the procedure option information in catalog table SYSIBM.SYSPSMOPTS is not removed. To completely remove the procedure definition, including its source and options, select the Start Stored Procedure Builder pop-up menu choice from the Procedures folder.
You cannot drop a procedure if a trigger definition contains a CALL statement with the name of the procedure.