Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in DB2
- 3 Answers
- 28681 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 datacom db?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What are the functions in DB2?
What is CHECK PENDING ?
What is PRIME TABLE and what are the uses of it
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What is the syntax of SELECT statement when embedded in a COBOL program?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
COBOL 
