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
What is role in db2?
How many databases are there?
What is load replace in db2?
What is bufferpool in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is database alias db2?
What is with ur in db2?
Can you use max on a char column?
What is ibm db2 database?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is access path in db2?
How does cobol compile db2 program?
What action db2 takes when a program aborts in the middle of a transaction?
Are view updateable?
How do you select a row using indexes in db2?