what is REORG? what is the use?
- 4 Answers
- 16056 Views
- I also Faced
- E-Mail Answers
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
load utility
| Is This Answer Correct ? | 1 Yes | 0 No |
Why do we need reorg in db2?
what is the difference between normal select query and currosor
What db2 400?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
Define db2 and its databases?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Explain correlated sub-queries.
Can SQL statements/queries be included in a copybook?
How would you find out the total number of rows in a db2 table?
What is plan in cobol db2?
What is the picture clause of null indicator variable?
COBOL 
