What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run?

Answer Posted / guest

The question should be how much space can be reclaimed from
dropped tables, that would be PERCDROP from
SYSIBM.SYSTABLEPART

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What parameters are used to control the free space in DB2?

640


Differentiate between cs and rr isolation levels? Where do you specify them?

575


How do I add a column to a table in db2?

616


Explain about mirror activator disk mirroring?

554


Can we delete records from view?

556






What is db2 plan table?

612


How do I optimize a query in db2?

611


Is db2 relational database?

567


What is precompiler in db2?

583


What does db2 blu stand for?

658


Can one database have multiple instances?

579


What is ibm db2 connect?

570


How do you find the maximum value in a column in db2?

646


What is null value in db2?

557


What is bufferpool in db2?

574