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
 

 

RUNSTATS Methodology

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

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jun 25, 2013 7:20 pm    Post subject: RUNSTATS Methodology
Reply with quote

How and when are RUNSTATS generated on your systems? Is everyone permitted to see them or is the output restricted?

Scheduled job? Ad-hoc by someone? DBA when they think they need to?

Are there restrictions on who can initiate a RUNSTATS or can anyone? Is this for some technical reason or the old "only a DBA can do this"?

I have a client that has (what i believe to be) some awful-running processes. They rarely produce RUNSTATS and few know how or are permitted to run EXPLAIN.
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1754
Location: Bloomington, IL

PostPosted: Tue Jun 25, 2013 7:39 pm    Post subject:
Reply with quote

Bearing in mind that I'm describing our development sysplex...

Anyone can execute RUNSTATS on their data bases and table spaces as needed. Few are capable of doing so; we have tools for creating "shadow" copies of production data bases, and most developers do no more than run those tools. I don't think that we have a tool to generate RUNSTATS JCL and control cards, although we have a scary amount of abandonware that hasn't been reviewed in (in some cases) decades and that no one understands anymore.

When I was at IBM about 15-20 years ago, we wrote and scheduled our own utility jobs for production. Generally, they had to be blessed by a DBA, who would seldom do anything but say "Yes" or "No" (we developers would write all DDL, control cards, etc).
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jun 26, 2013 12:07 pm    Post subject:
Reply with quote

Hello D.sch,

In my previous company we never ran Runstats Utility, but we collected stats via REORG utility during the weekends which are triggered by RTS and everybody had access to the SYSPRINT to check the details of stats and also everybody had access to production to query sysibm.* tables or check stats through RC/Query panels. In development everybody had access to runstats, but usually whenever table is loaded, stats are updated by Load utility itself. If stats are required for any specific tables, a request is made to the DBA. They are permitted to run explain, but only a very few know how to run explain & analyze.

In my current company, lots of runstats are being run and most of the options are used, basically it depends on the type of application, some are run daily in the batch and some are in the weekends and the utility is to be run only by the DBA. Mostly everybody will be having access to production SYSIBM.* tables to query the stats and also sysibm.* tables are copied from production to developement, so developers can see the prod stats in Development environment itself. They are permitted to run explain, but only a few know how to run explain & analyze.

Thanks,
Sushanth
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 How to embed RUNSTATS in an applicati... ravindra.vadali DB2 4 Tue Oct 15, 2013 8:33 pm
No new posts Is Rebind required for dynamic SQL Co... Furor DB2 1 Thu Sep 19, 2013 9:35 am
No new posts EXECUTION ABENDED, REASON=X'00E40347'... Jimy Carol DB2 2 Sat Sep 07, 2013 6:35 pm
No new posts Is it mandatory to Rebind after we pe... Furor DB2 1 Fri Mar 01, 2013 2:02 pm
No new posts Execute RUNSTATS on all the DB2 tables maverick05 DB2 5 Wed Jun 06, 2012 10:26 pm


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