Interested to Buy Any Domain ? << Click Here >> for more details...
What is reorg in DB2
- 3 Answers
- 28618 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 coalesce in db2?
What is explain in db2?
What is rct?
What is Skeleton cursor table (SKCT)?
Which component is responsible for db2 startup and shutdown?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What is DCLGEN ?
What can the Locate option of the Repair Utility accomplish?
is it possible to get -811 error when you use cursors. why?
wht steps we need will coding cobol and db2 pgm ?
SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.
What is difference between rollback and commit?
COBOL 
