IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Store Procedures - Call Log


 
IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic
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
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

Global Moderator


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

PostPosted: Wed Apr 30, 2014 12:03 am
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
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

Global Moderator


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

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

To know more on WLM , please read below,

Use [URL] BBCode for Links

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

Use [URL] BBCode for Links

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 All times are GMT + 6 Hours
Forum Index -> COBOL Programming
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts Call Natural program with rexx CLIST & REXX 2
No new posts CALL statement in COBOL for VSE COBOL Programming 3
No new posts Need example for CALL 'ISRSUPC' in COBOL COBOL Programming 2
No new posts trigger enter key automatically call ... CICS 17
No new posts Need a Macro to compare datasets and ... All Other Mainframe Topics 2

Back to Top