Answer Posted / 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 |
Post New Answer View All Answers
How do I delete a table in database?
How do you eliminate duplicate values in db2?
Can we update view in db2?
What are the two types of logging in the db2 database? Explain them.
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to find the number of rows in a db2 table?
What does a deadlock mean in DB2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Where can you declare a cursor in a cobol-db2 program?
What is the difference between drop table and delete table?
What is a db2 package?
Highlight all the advantages that are attached to a package.
What is check constraint. Explain with example.
What is reorg and runstats in db2?
What is the use of predicate?