What is reorg in DB2
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srini
REORG will reorganise the records as per the clustered
Index/index fields,so that the system can access records
easily thru which the access cost will come down
drastically,so its always advisable to run REORG after
every mass inserts/updates/deletes on table.
| Is This Answer Correct ? | 30 Yes | 9 No |
Answer / vivekk ram
when ever a record is deleted, it marks the record to be deleted but the physically it is not deleted in db. So using reorg command is ran, it physically deletes the record from db.
Please correct me, if i'm wrong..
| Is This Answer Correct ? | 0 Yes | 0 No |
can you use symbolic parameters in JOB?
What is the latest version of ibm db2?
why we create view.
What is the use of db2 optimizer?
How to create backup table in db2?
Who uses db2?
What is innodb buffer pool?
How can you do the explain of a dynamic sql statement?
What do you mean by storage group (stogroup)?
what are the SQL codes u freequently got?
How do I start db2 in windows?
How is the value function used?