Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Store Procedures - Call Log

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Tue Apr 29, 2014 11:09 pm    Post subject: Store Procedures - Call Log
Reply with quote

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.
Back to top
View user's profile Send private message

Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1696
Location: NY,USA

PostPosted: Wed Apr 30, 2014 12:03 am    Post subject:
Reply with quote

You can check the corresponding WLM and if SP is called from a distributed side then you can check the corresponding Server logs.
Back to top
View user's profile Send private message
cvishu

Active User


Joined: 31 Jul 2007
Posts: 136
Location: india

PostPosted: Wed Apr 30, 2014 5:18 am    Post subject:
Reply with quote

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 ?
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1696
Location: NY,USA

PostPosted: Wed Apr 30, 2014 11:43 am    Post subject:
Reply with quote

To know more on WLM , please read below,

http://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

http://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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts Need help in triggering a PL1 module ... Varungv99 IMS DB/DC 0 Fri Apr 07, 2017 10:01 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Cobol EZASOKET call to SETSOCKOPT fails Andi1982 COBOL Programming 6 Thu Oct 06, 2016 7:12 pm
No new posts Strange EXEC function call in z/VM Willy Jensen CLIST & REXX 3 Wed Oct 05, 2016 2:07 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us