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

Can we delete records from view?

569


What is ibm db2 client?

529


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

621


What is a db2 tablespace?

611


What is database reorganization?

597






Why db2 is called db2?

601


What action db2 takes when a program aborts in the middle of a transaction?

666


What is bind in db2?

610


How to find the maximum value in a column in the db2 database?

622


What is coalesce in db2?

691


What is netezza database?

581


List down the types of triggers in the db2 database?

599


Can there be more than one cursor open for any program?

668


what is the sqlcode -501

11328


How do I import a csv file into db2?

572