View previous topic :: View next topic
|
Author |
Message |
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. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
|
|
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 |
|
|
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 ? |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
Back to top |
|
|
|