Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in DB2
- 3 Answers
- 28675 Views
- Virtusa, I also Faced
- E-Mail Answers
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 |
The only place of VSAM KSDS in DB2 is?
How do I connect my db2 database to ibm?
What is scrollable cursor in db2?
What are the levels of isolation available with DB2V4
What is copy pending status in db2?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is multi row fetch in db2?
what is REORG? what is the use?
how to fetch first 100 rows in db2
What does it mean if the null indicator has -1, 0, -2?
Give a brief description of db2 isolation levels?
what is the name of the default db2 catalog database?
COBOL 
