Answer Posted / s
It is not necessary to run the REORG utility after the Load
utility unless the data needs to be reclusterd based on the
clustering sequence and reclaim free space. If the data
input to the load data is already sorted in clustering
sequence the need for a REORG is unnecessary.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is reorg?
How will you return the number of records in table?
What is sqlca’s maximum length?
What is commit in db2?
What is host variable?
What is copy pending and check pending in db2?
How and when does the db2 enforces the unique key?
How do you select a row using indexes in db2?
When do you specify the isolation level?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the purpose of using commit?
Which isolation level provides highest data integrity?
What is the difference between spufi and qmf?
Name the lockable units in DB2?