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 is cascading rollback?
Is ibm db2 open source?
Define sqlca.
Where do you specify them?
What is the difference between drop table and delete table?
What is catalog database in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Which isolation level provides highest data integrity?
What is the meaning concurrency in the db2 database?
How connect db2 database to datastage?
What is reorg and runstats in db2?
What is the use of reorg in db2?
What is dbrm? What it contains?
How would you find out the total number of rows in a db2 table?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
