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
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the difference between drop table and delete table?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is host variable?
How do you eliminate duplicate values in db2?
What are the two types of logging in the db2 database? Explain them.
can we view the access paths created by dbrm ? how ? thx
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is dbrm?
What kind of database is db2?
How to compare data between two tables in db2?
What are catalog tables in db2?
What is explain in db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is schema in db2?