Interested to Buy Any Domain ? << Click Here >> for more details...
What does the REORG Utility do?
- 2 Answers
- 13876 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 |
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What is a bind in db2?
What is the self-referencing constraint?
How do I start db2 in windows?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
What is CHECK PENDING ?
How to check table size in db2 sap?
What is an instance in db2?
wt is view ? wht r the restrictions for view ?
How many types of page locks can be held in db2?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
what is the difference between normal select query and currosor
COBOL 
