Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in DB2
- 3 Answers
- 28499 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 |
How will fetch last 5 rows from table in db2
What is cobol db2?
List some fields from sqlca?
How to solve S0C7 abend with out using DISPlay in 10 mins?
what is SMP/E? and what are the major steps of it? thanks...
What is the role of schema in the db2 database?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
how we will do null data selection in cobol-db2 program
what is db2 restart?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
what's the best lock size that you could use when you create a tablespace?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
COBOL 
