Toad World® Forums

Counting Executions of a Stored Procedure

Hi all, I have been researching for a couple hours and searching through various sys tables and I haven’t seen a way to easily find the number times a particular stored procedure has run. Is there an easy way to find this count? If so, please inform me of this method. Thanks!

Depending on your version of DB2 you can set the DB CFG parameters mon_rtn_data to base and mon_rtn_execlist to ON. These parameters were added in DB2 V10.1 Fix Pack 2.

www-01.ibm.com/…/r0060775.html

www-01.ibm.com/…/r0060774.html

Thanks,

Eric S