Hi,
I have a db2 9.7 database that was converted from db2 9.5 on an AIX P7AIX platform. I'm using Enterprise edition. I dropped a large table that contained an XML column. I did not expect to see the database size shrink because the tablespace "reclaimable space" flags were not set but yet it was reduced by almost 49 GB. Can anyone explain why I had a reduction in the database size? The table resided in the TSPACE_32K tablespace.

db2 "CALL GET_DBSIZE_INFO(?, ?, ?, 0)"

Before: 329,386,827,776
After: 280,499,597,312
Savings: 48,887,230,464

db2 "SELECT varchar(tbsp_name, 30) as tbsp_name, tbsp_type, RECLAIMABLE_SPACE_ENABLED FROM TABLE(MON_GET_TABLESPACE('',-2))"

TBSP_NAME TBSP_TYPE RECLAIMABLE_SPACE_ENABLED
---------------------------- ---------- -------------------------
SYSCATSPACE DMS 0
TEMPSPACE1 SMS 0
USERSPACE1 DMS 0
SYSTOOLSPACE DMS 0
TSPACE_4K DMS 0
TSPACE_8K DMS 0
TSPACE_16K DMS 0
TSPACE_32K DMS 0
SYSTOOLSTMPSPACE SMS 0
TEMPSPACE2 SMS 0
USERTEMPSPACE2 SMS 0