Answer Posted / 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 |
Post New Answer View All Answers
What is dbrm?
How can we read records for specific member in CL? AND rpg?
What is host variable in db2 cobol?
What is schema in db2?
Why do we need reorg in db2?
How do I delete a table in db2?
What is the default page size of buffer pools?
What are the various isolation levels possible?
Can you use max on a char column?
What is cursor with hold option in db2?
How do you eliminate duplicate values in db2?
What types of tables are there in the db2 database?
What is the maximum No of rows per page?
What happens in bind step in a db2 program?
What is difference between isnull and coalesce?