Interested to Buy Any Domain ? << Click Here >> for more details...
What does the RUNSTATS Utility do?
- 4 Answers
- 20826 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 dbrm library?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the usage of open cursor command?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is DYNSLT keyword? How do you perform selection using DYNSLT
is it possible to get -811 error when you use cursors. why?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
How and when does the db2 enforces the unique key?
i want to delete 20th million record how ?
How can you find out the # of rows updated after an update statement?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is a DB2 bind?
COBOL 
