What is reorg in database?
Answer / 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 |
What is the role of data manager in the db2 database?
Give a brief description of db2 isolation levels?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
Explain about mirror activator disk mirroring?
What is a DB2 catalog?
Update command
What is meant by a unit of recovery?
how to copy the host variables from ps file into cobol program other than include statement
What is a root page?
What does the RUNSTATS Utility do?
how will you retrieve first record in table
What is copy pending and check pending in db2?