Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

How to execute stored procedure in db2 command editor?

0 Answers  

What does DML stand for and what are some examples of it?

3 Answers   IBM,

What is meant by a unit of recovery?

1 Answers  

When will you chose to run RUNSTATS?

1 Answers  

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

Is db2 relational database?

0 Answers  


5 Answers  

what is the soft code for deadlock ?

2 Answers   Logica CMG,

What is a predicate?

1 Answers  

Explain about dbrm.

0 Answers  

How to take backup of table in db2?

0 Answers