MVSFORUMS.com

Martin · Beginner Joined: 20 Mar 2006 Posts: 133 Topics: 58

Hi All,

We are asked to RUN STATS to few of the jobs in production.Can some one please explain what is the use of the adding RUN STATs??

Thanks,
Mt

jsharon1248 · Posted: Tue Nov 06, 2007 12:53 pm Post subject:

Click on the Quick Manuals link at the top of this page, then the DB2 V8 Utility Guide and Reference link, then review the description for RUNSTATS. That's a good place to start.

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Martin,

RUNSTATS is used to collect information about the characteristics of data in table spaces, tables etc.

You can start you readings from here
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNUGJ12/2.27?DT=20050323210436

bauer · Posted: Thu Nov 08, 2007 1:55 am Post subject:

Martin,

well, rebind could bei helpful after runstats ....

regards,
bauer

pcsingh_2000 · Posted: Fri Nov 09, 2007 12:22 pm Post subject:

Runstat collects the statistics like number of records in a table, repeating data, index rows and it's characteristics. that means it is now known to db2 about the data/index present for that tablespace. When you rebind after runstat, the access path is rebult again according to current statistics. hence better performance for the queries..

regards,
Prakash.
_________________
prakash c. singh
voice:00-91-93315 16675