Interested to Buy Any Domain ? << Click Here >> for more details...
What does the REORG Utility do?
- 2 Answers
- 14038 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 |
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
How do you retrieve the data from a nullable column?
Do we need cursor for Count(*)?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What are some characteristics of columns that benefit from indexes?
What does an outer join do?
how we will do null data selection in cobol-db2 program
What are the disadvantages of PAGE level lock?
What is package in cobol db2?
What are db2 objects?
What is normalization and what are the five normal forms?
Explain how can you do the explain of a dynamic sql statement?
COBOL 
