Interested to Buy Any Domain ? << Click Here >> for more details...
What does the REORG Utility do?
- 2 Answers
- 14020 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 |
Name the various locking levels available?
Explain various types of locks in db2?
What is pagespace?
What is sqlca?
How do I optimize a query in db2?
What is an alias and how does it differ from a synonym?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is an intent lock?
What is the difference between spufi and qmf?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
Define declaration generator (dclgen).
COBOL 
