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

List out the data types available.

704


what is utility for parm lib

1886


Explain about mirror activator disk mirroring?

561


What is buffer pool in the db2 database?

622


How to create db2 table in mainframe?

633






Explain the function of data manager.

635


What is temporal table in db2?

605


Which isolation level provides highest data integrity?

599


What is explain plan in db2?

592


What is the physical storage length of the data types date, time, and timestamp?

612


What is deadlock in db2?

587


What is dbrm in db2 database?

591


What is the role of schema in the db2 database?

653


What is the difference between plan and package in db2?

581


What is db2 catalog database?

582