Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is difference between rollback and commit?
What is sqlca?
Can one database have multiple instances?
Explain the function of data manager.
What is the difference between using bind () and rebind () methods of naming class?
Give a brief description of db2 isolation levels?
What is data manager?
What is dbrm? What it contains?
What does runstats do in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the role of data manager in the db2 database?
Can there be more than one cursor open for any program?
What is bind plan?
What is the difference between spufi and qmf?
What is reorg and runstats in db2?
