Answer Posted / vasuki🐍
reorganizes the table and its indexes by
rebuilding the index data into unfragmented and contiguous area on the disk.
Normally after a large amount of INSERT, UPDATE, DELETE activities on data tables, we generally need a REORG.
After a table space reorganization the fragments are moved around and clustered,
however the database still utilizes the old statistic to query the data.
So it is recommended to run a RUNSTATS on the table.
This command updates the statistic information.
Besides it makes sure that the DB2 optimizer takes advantage of the refreshed statistic information.
Reorg>>runstats
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are bind concepts in db2 cobol?
What is buffer pool?
What is the max length of sqlca?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to run db2 command in windows?
Explain in brief how does db2 determine what lock-size to use?
What do you mean by storage group (stogroup)?
What is database alias db2?
What is ibm db2 database?
Which component is responsible for processing sql statements and selecting access paths?
Which component is responsible for db2 startup and shutdown?
How do I delete a column in db2?
what is the responsibility of the construction superintendent
How can you classify the locks in db2?
How to rename a table in DB2 ?