Store Procedures - Call Log

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

Hi ,
Is there a way to determine which programs call a given DB2 Stored Procedure(SP) and how many times in a given day.
Basically i am looking for some kind of log , where i can see the number of times a SP is triggered and by who.

Thanks in advance.

Rohit Umarjikar · Posted: Wed Apr 30, 2014 12:03 am

You can check the corresponding WLM and if SP is called from a distributed side then you can check the corresponding Server logs.

cvishu · Active User Joined: 31 Jul 2007 Posts: 136 Location: india

Thanks for the reply rohit , i am not very familiar with WLM . Though i am trying to google it , could you please give some pointers as to how to get there and verify in mainframe , is ther any command / pannel that i need to go to ?

Rohit Umarjikar · Posted: Wed Apr 30, 2014 11:43 am

To know more on WLM , please read below,

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.inst%2Fsrc%2Ftpc%2Fdb2z_wlmmanagementsp.htm

Also please query SYSIBM.SYSROUTINES with your SP name and then you should be able to see the WLM -job name

publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.sqlref%2Fsrc%2Ftpc%2Fdb2z_sysibmsysroutinestable.htm

Once, you get the JOB Name go to SPOOL and look for the logs to investigate further and also reach out to your DBA to get required answer to your initial question.