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
 

 

need to find frequency of stored procedure being used.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Wed May 25, 2011 12:15 pm    Post subject: need to find frequency of stored procedure being used.
Reply with quote

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

gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Wed May 25, 2011 5:13 pm    Post subject:
Reply with quote

Hi,

You can use some DB2 Monitor tools like Insight and look for threads.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Wed May 25, 2011 5:16 pm    Post subject: Reply to: need to find frequency of stored procedure being u
Reply with quote

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
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Wed May 25, 2011 6:58 pm    Post subject:
Reply with quote

-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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2435
Location: Netherlands, Amstelveen

PostPosted: Wed May 25, 2011 10:35 pm    Post subject:
Reply with quote

SMF ?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu May 26, 2011 12:53 pm    Post subject:
Reply with quote

PeterHolland wrote:
SMF ?

Is that a question about what SMF is, or a suggestion to look at SMF ?
just in case : http://en.wikipedia.org/wiki/IBM_System_Management_Facilities
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu May 26, 2011 2:43 pm    Post subject:
Reply with quote

icon_smile.gif - Peter must be referring to look at SMF reocrds.

have fun...icon_smile.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2435
Location: Netherlands, Amstelveen

PostPosted: Thu May 26, 2011 2:45 pm    Post subject:
Reply with quote

Anuj Dhawan wrote:
icon_smile.gif - Peter must be referring to look at SMF reocrds.

have fun...icon_smile.gif


Anuj, you got it.

And have fun too.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts find RACF group for access to spooled... jzhardy JCL & VSAM 1 Mon May 08, 2017 11:46 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts find particular member name in PDS us... ravi243 CLIST & REXX 10 Mon Dec 19, 2016 6:44 pm


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