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 |
What is rct?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What does an outer join do?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What are the various data types available in db2?
What is pagespace?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is -904 sql code? How to resolve it?
what is a corelated subquerry?
What does the sqlcode of -818 pertain to?
what is cursor stability?
Mention some fields that are a part of sqlca.