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
How to retrieve rows from a db2 table in embedded sql?
Explain about open switch business continuity software?
When the like statement is used?
Where do you specify them?
How many databases can be created inside an instance in db2 ?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is explain plan in db2?
Define predicate?
What is image copy in db2?
what is db2 restart?
What is the result of open cursor statement?
What is commit in db2?
How can we read records for specific member in CL? AND rpg?
How would you find out the total number of rows in a db2 table?
What is db2 instance?
