Interested to Buy Any Domain ? << Click Here >> for more details...
What does the REORG Utility do?
- 2 Answers
- 14015 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 many Buffer pools are there in DB2 and what are they?
What are bind parameters in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is a collection in db2?
What information can you find in SYSIBM.SYSLINKS table?
What is access path in db2?
What is package in db2 mainframe?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How to access db2 tables in mainframe?
What is null indicator in db2?
i have a db2 variable how do u declare tht into working storage section ?
What are the advantages of using a PACKAGE?
COBOL 
