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 the physical storage length of the data types: date, time, timestamp in the db2 database?
what is db2 restart?
How can you quickly find out the # of rows updated after an update statement?
What is difference between rollback and commit?
Explain packages.
What is scrollable cursor in db2?
What is the max length of sqlca?
What is data manager?
Explain about dbrm.
Is ibm db2 open source?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is buffer pool?
Why cursor is used in db2?
How to get the ddl of a table in db2?
How to take backup of table in db2?