Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in database?
- 1 Answers
- 1986 Views
- I also Faced
- E-Mail Answers
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 |
How do I start db2 in windows?
What should be specified along with a cursor in order to continue updating process after commit?
How do you run JCL in cobol program
what is the soft code for deadlock ?
Is db2 a programming language?
Explain db2.
What are bind parameters in db2?
What is the difference between spufi and qmf?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What information is held in SYSIBM.SYSCOPY?
What is the SQL Communications Area and what are some of its key fields?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
COBOL 
