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
How many types of page locks can be held in db2?
Explain about dbrm.
Is it possible using max on a char column?
What is db2 and what is the use of db2 optimizer?
Explain dclgen.
Mention the different locking levels that are available in db2.
What does sqlcabc has?
What is the physical storage length of date data type?
How does db2 sample database connect?
What is view db2?
Define buffer pool.
How to find the number of rows in a db2 table?
How do you pull up a query which was previously saved in qmf?
What are union and union all?
What is null indicator in db2?
