Interested to Buy Any Domain ? << Click Here >> for more details...
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
How can you count the number of rows from a table tab?
Define data page.
What is the difference between cursor stability and repeatable read isolation levels?
How do you pull up a query which was previously saved in qmf?
What does db2 plan contain?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Before you give the explain statement, what are the prerogatives?
What is reorg and runstats in db2?
What is the use of reorg in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What is a trigger in the db2 database?
What is query_cache_limit?
What are the rules for db2 programming?
Mention the various locks that are available in db2.
How do I delete a table in db2?
