How do you find which procedures are being used in database?

Showing Answers 1 - 0 of 0 Answers

I am not too sure if I understand our question properly. If you wanted to find all the stored procedures defined to the database with a CREATE PROCEDURE command (let's say DB2), then run a query from SYSIBM.SYSROUTINES. If you want the parameters associated with these stored procedures, then run a query from SYSIBM.SYSPARMS.


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions