What is reorg in DB2
- 3 Answers
- 27760 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 |
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is the difference between cursor stability and repeatable read isolation levels?
What is the use of dclgen in db2?
What is usage pointer in cobol?
What is cursor stability?
What are the contents of dclgen?
What is universal database?
What is the physical storage length of timestamp data type?
Is Cursor exicutable ?
what is check point and restart Logic ? why do we go for that ??
What does DML stand for and what are some examples of it?
COBOL 
