what is REORG? what is the use?

Answers were Sorted based on User's Feedback

what is REORG? what is the use?..

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

what is REORG? what is the use?..

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

what is REORG? what is the use?..

Answer / deepak dada

used for reorganising the datas in the tables after the
load utility

Is This Answer Correct ?    1 Yes 0 No

what is REORG? what is the use?..

Answer / kathir

Answer #3 is exactly correct

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is the use of runstats in db2?

0 Answers  

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

What is a SELECT statement?

1 Answers  

What is the syntax for FETCH in DB2 ?

0 Answers   MCN Solutions,

What action db2 takes when a program aborts in the middle of a transaction?

0 Answers  

what is cursor stability?

2 Answers   IBM,

What happens in bind step in a db2 program?

0 Answers  

What are PACKAGES ?

3 Answers  

How do you retrieve the data from a nullable column?

2 Answers  

What is phantom read in db2?

0 Answers  

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.

5 Answers  

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. 

2 Answers   RBS,