You can determine how much of your table space is currently in use with the MON_GET_TABLESPACE table function. The information this function returns can help you determine whether you should attempt to reclaim free storage.
Restrictions
Although you can determine various usage attributes about all your table spaces, only table spaces created with DB2® Version 9.7 or later have the reclaimable storage capability. If you want to be able to reclaim storage in table spaces created with earlier versions of the DB2 product, you either must unload then reload the data into a table space created with DB2 Version 9.7, or move the data with an online move.To determine how much free space exists below the high water mark:
TBSP_NAME RECLAIMABLE_SPACE_ENABLED TBSP_FREE_PAGES TBSP_PAGE_TOP TBSP_USABLE_PAGES
------------------------------ ------------------------- -------------------- -------------------- --------------------
TEMPSPACE1 0 0 0 1
USERSPACE1 1 0 1568 1568
SYSTOOLSTMPSPACE 0 0 0 1
TBSP1 1 0 1632 1632
SMSDEMO 0 0 0 1
SYSCATSPACE 1 2012 10272 12284
IBMDB2SAMPLEREL 1 3328 736 4064
TS1 1 3584 480 4064
TS2 1 3968 96 4064
TBSP2 1 3968 96 4064
TBSAUTO 1 3968 96 4064
SYSTOOLSPACE 1 3976 116 4092
12 record(s) selected.