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
Explain how can you do the explain of a dynamic sql statement?
What is schema in db2?
What is the use of runstats in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Who uses db2?
Explain various types of locks in db2?
What is dclgen (declaration generator)?
Explain what are the various isolation levels possible?
What are concurrency issues?
What is an instance database?
What types of tables are there in the db2 database?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is db2 purescale?
What is commit in db2?
What are bind parameters in db2?