What does the RUNSTATS Utility do?

Question Posted / guest

4 Answers
20529 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What does the RUNSTATS Utility do?..

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

What does the RUNSTATS Utility do?..

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

What does the RUNSTATS Utility do?..

Answer / srinivasa yadav

RUNSTAT: IT GIVES THE LATEST INFORMATION OF THE
INDEXES,TABLESPACES etc

Is This Answer Correct ?

10 Yes

1 No

What does the RUNSTATS Utility do?..

Answer / sunil1405

reclaims free spcace, orders the records

Is This Answer Correct ?

1 Yes

29 No

Post New Answer