Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in DB2
- 3 Answers
- 28783 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 drop table?
What is cursor with hold option in db2?
What is host variable?
What is cobol db2?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What's The Error Code For Unique Index Voilation?
Can you define an Index if the table size less than 10 PAGES?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is lock escalation?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
COBOL 
