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

Showing Answers 1 - 8 of 8 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