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 null value in db2?
What is the difference between db2 and oracle?
Is db2 a mainframe database?
Who uses db2?
What is the difference between plan and package in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How do I start db2 in windows?
How do I delete a table in db2?
How can you do the explain of a dynamic sql statement?
What is cobol db2?
What is the syntax for FETCH in DB2 ?
What are the contents of a dclmgen?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Can there be more than one cursor open for any program?
What is schema in db2?
