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 dbrm? What it contains? When it will be created?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How would you find out the total number of rows in a db2 table?
What is bind and rebind in db2?
What is null value in db2?
Comment whether the cursor is closed during commit or not.
How to check sequence on a table in db2?
How to find schema of a table in db2?
Name the various locking levels available?
What is universal database?
Explain db2.
can we view the access paths created by dbrm ? how ? thx
Explain package in db2 and its advantages?
What is phantom read in db2?
Which component is responsible for db2 startup and shutdown?