What does the RUNSTATS Utility do?
- 4 Answers
- 19390 Views
- I also Faced
- E-Mail Answers
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 |
What is the syntax of SELECT statement when embedded in a COBOL program?
What is cloudant database?
What is the difference between nvl and coalesce?
What is the cascade rule and how does it relate to deletions made with a subselect?
what is Static and dynamic linking
When can an insert of a new primary key value threaten referential integrity?
When would you prefer to use VARCHAR?
Which command is used to remove all rows from a table?
Mention data types used in db2 ?
Explain the use of the WHERE clause.
What is null value in db2?
What are the three types of page locks that can be held?
COBOL 
