View previous topic :: View next topic
|
Author |
Message |
Keanehelp
New User
Joined: 27 May 2008 Posts: 71 Location: USA, CA.
|
|
|
|
Hi,
Can anyone please let me know, how can we find out how many times a Stored Procedure has been executed in last X days.?
Thnx |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Hi,
You can use some DB2 Monitor tools like Insight and look for threads. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
it would be better always to try to reply in terms of a vanilla(*) environment
(*) no additional products, nor site specific tools |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
-DISPLAY PROC gives you some info, but not the number of executions.
If you have Displays in your stored procedure, you can count in the SYSOUT of the WLM-job (in SDSF a job possibly something like ssidWLM*)
If you have DB2 traces on , at least on Package Level , you can find it in the SMF records.
I guess the question is similar to 'how many time this package was needed?'
and the answer to that is : "Not so Easy" |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
SMF ? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
- Peter must be referring to look at SMF reocrds.
have fun... |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Anuj Dhawan wrote: |
- Peter must be referring to look at SMF reocrds.
have fun... |
Anuj, you got it.
And have fun too. |
|
Back to top |
|
|
|