Interested to Buy Any Domain ? << Click Here >> for more details...
what is REORG? what is the use?
- 4 Answers
- 15468 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 are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is copy pending status in db2?
What is rct?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What is a predicate?
What is the information associated with sysibm.syslinks table?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
How many databases are there?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What is a dbrm in db2?
What is the physical storage length of time data type?
COBOL 
