what is REORG? what is the use?
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 |
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
Can you use max on a char column?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is a DB2 bind?
What does runstats do in db2?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
Which isolation level provides highest data integrity?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
How do you filter out the rows retrieved from a Db2 table ?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is bufferpool in db2?
What is the difference between base table and view?