Interested to Buy Any Domain ? << Click Here >> for more details...
What does the REORG Utility do?
- 2 Answers
- 13878 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
REORG is a db2 utlity, to reclustering, reclaim the table
space. it used when the bulk updates or inserts happens.
| Is This Answer Correct ? | 23 Yes | 5 No |
Answer / harsha
Reorg is done when
1) clustratio <80% ( for IBM stranded)
2) when altering the Cluster object
3) when dropping the cluster object
4) when bulk updates and inserts are done
5) space reclamation
6) when a table is changed from compression to decompression
mode
| Is This Answer Correct ? | 6 Yes | 2 No |
What is usage pointer in cobol?
What is a SELECT statement?
Which transaction use a command thread ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
how to unload different table data into different gdg files/ vsam files.
What is correlation names?
How many types of page locks can be held in db2?
What does db2 plan contain?
What are union and union all?
is it compulsory commitment control in journal?
Mention the various locks that are available in db2.
What is the syntax for seeing the columns and data types of a table in the db2 database?
COBOL 
