Answers were Sorted based on User's Feedback
Answer / aasif
A common maintenance task performed by database
administrators is the reorganization of data in tables and
indexes, called "reorg." Table reorganization is used to
defragment a table, reclaim free space, and eliminate
overflow rows in order to improve data access performance.
Optionally it can be used to reorder data in the order of a
particular index, to optimize queries that use that index.
|Is This Answer Correct ?||10 Yes||1 No|
Answer / 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|
Answer / deepak dada
used for reorganising the datas in the tables after the
|Is This Answer Correct ?||1 Yes||0 No|
Answer / kathir
Answer #3 is exactly correct
|Is This Answer Correct ?||0 Yes||0 No|
What is the use of runstats in db2?
what's the best lock size that you could use when you create a tablespace?
What is a SELECT statement?
What is the syntax for FETCH in DB2 ?
What action db2 takes when a program aborts in the middle of a transaction?
what is cursor stability?
What happens in bind step in a db2 program?
What are PACKAGES ?
How do you retrieve the data from a nullable column?
What is phantom read in db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.