Interested to Buy Any Domain ? << Click Here >> for more details...
what is REORG? what is the use?
- 4 Answers
- 15854 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 |
What is a Resource Control Table(RCT)? Describe its characteristics.
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
define clustering index.
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is release/acquire in bind?
What is a lock?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is the cascade rule and how does it relate to deletions made with a subselect?
What is concurrency?
Can SQL statements/queries be included in a copybook?
COBOL 
