Hello,

Regarding reclaimable storage:
http://publib.boulder.ibm.com/infoce...uw/v9r7/topic/
com.ibm.db2.luw.admin.dbobj.doc/doc/c0055392.html states that

"For a DMS or automatic storage table space created in Version
9.7, you can use reclaimable storage to return unused storage
to the system for reuse."

If I don't know which version DB2 had when a given tablespace was
created, how do I than determine if the tablespace uses reclaimable
storage or not?

--
Troels

On Jan 24, 9:02*am, Troels Arvin <tro... (AT) arvin (DOT) dk> wrote:
Hi. You can use the following query to see which tablespaces are
enabled for reclaimable storage:

SELECT TBSP_NAME, TBSP_TYPE, RECLAIMABLE_SPACE_ENABLED FROM TABLE
(MON_GET_TABLESPACE('',-2))

Kelly