How to check reclaimable space enabled on DB2 tablespace with MON_GET_TABLESPACE

Question: How can I check if a DB2 database  tablespace  has reclaimable space enabled?  A REORG completed and I need to reclaim the space

Answer:  You can find metrics about DB2 tablespaces using the  MON_GET_TABLESPACE table function .

Use the reclaimable_space_enabled column . It returns an smallint . If the value returned is 1 – reclaimable space is enabled. If  0 is returned , reclaimables space is not enabled.

select substr(TBSP_NAME,1,14),reclaimable_space_enabled from table (MON_GET_TABLESPACE(NULL,-1)) WHERE TBSP_NAME NOT  LIKE ('SYS%')

Read More on DB2 reorg options

Reorg table DB2

DB2 table reorg and table truncate

DB2 Used Space and REORG