What does the RUNSTATS Utility do?
Answers were Sorted based on User's Feedback
Answer / s
RUNSTATS does not reclaim space nor orders records, its the
REORG utility that will reorganize the data records.
RUNSTATS collects statistics about the data in the table
like, cardinality statistics, frequency statistics that
will be used by the optimizer to determine a good access
path.
Is This Answer Correct ? | 30 Yes | 3 No |
Answer / andank
RUNSTATS does not reclaim space nor orders the records.
Here is info from the DB2 Manual:
The RUNSTATS online utility gathers summary information
about the characteristics of data in table spaces, indexes,
and partitions. DB2 records this information in the DB2
catalog and uses it to select access paths to data during
the bind process. It is available to the database
administrator for evaluating database design and to aid in
determining when table spaces or indexes must be
reorganized.
Output: RUNSTATS updates the DB2 catalog with table space
or index space statistics or prints a report.
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / srinivasa yadav
RUNSTAT: IT GIVES THE LATEST INFORMATION OF THE
INDEXES,TABLESPACES etc
Is This Answer Correct ? | 10 Yes | 1 No |
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
What is a storage group (stogroup)?
What is a composite index and how does it differ from a multiple index?
What is the SQL Communications Area and what are some of its key fields?
Give the name of some fields form sqlca.
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
What is an instance database?
What is deadlock?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is reorg and runstats in db2?
Explain about mirror activator disk mirroring?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.