Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in DB2
- 3 Answers
- 28508 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 dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What is bind in db2?
List out the data types available.
What is cursor stability in db2?
How to define the a field which accepts value till 99999.99 in db2
What is the error code -803 ?
What is the use of db2?
What information is held in SYSIBM.SYSCOPY?
Is db2 a programming language?
What is view db2?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What are foreign keys in db2?
COBOL 
