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 |
What does the sqlcode of -818 pertain to?
What is meant by explain?
What does db2 plan contain?
how to execute qcmdexc in rpgle?plz write code also?
Explain the contention situations caused by locks?
What is SPUFI?
What techniques will be used to avoid deadlock??
how can i pull up a query which was previously stored in qmf
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
What is reorg and runstats in db2?
Define db2 and its databases?
Explain about rct in db2?