What does the RUNSTATS Utility do?
Answers were Sorted based on User's Feedback
Answer / s
RUNSTATS does not reclaim space nor orders records, its the
REORG utility that will reorganize the data records.
RUNSTATS collects statistics about the data in the table
like, cardinality statistics, frequency statistics that
will be used by the optimizer to determine a good access
path.
Is This Answer Correct ? | 30 Yes | 3 No |
Answer / 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 |
Answer / srinivasa yadav
RUNSTAT: IT GIVES THE LATEST INFORMATION OF THE
INDEXES,TABLESPACES etc
Is This Answer Correct ? | 10 Yes | 1 No |
What is the function of logging in the db2 database?
What is cursor in dbms?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What is check constraint. Explain with example.
What is the role of schema in the db2 database?
Do we need cursor for Count(*)?
What are the contents of dclgen?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
How do you retrieve the data from a nullable column?
What is the format (internal layout) of ?TIMESTAMP??
Differentiate between cs and rr isolation levels? Where do you specify them?
How do I copy a table in db2?