Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How to resolve deadlock issue
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is meant by union and union all?
what is utility for parm lib
What does db2 blu stand for?
Name the lockable units in DB2?
Discuss about db2 bind?
What is catalog database in db2?
What is the use of value function?
How to execute stored procedure in db2 command editor?
Explain the contention situations caused by locks?
What is sqlca’s maximum length?
Where can you declare a cursor in a cobol-db2 program?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
