Answer Posted / harish
Reorg is needed whenever indexed columns are updated frequently.
When indexed columns are updated frequently, then the index
for the table has to be created again.
So REORG utility is run which will drop the index and create
the index again for the table.
| Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
what are bind concepts in db2 cobol?
What is cloudant database?
What is a bind in db2?
How do I add a column to a table in db2?
What is a db2 cursor?
What is the use of dclgen in db2?
What are concurrency issues?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is reorg and runstats in db2?
What is db2 connect?
What are union and union all?
What is database alias db2?
How connect db2 database to datastage?
What parameters are used to control the free space in DB2?