Reclaimable Storage : Usage, Hints, Tips
FYI : Why only new tablespaces ?
• Index keys in existing tablespace point to data rows via their physical (tablespace-relative) addresses. Moving an extent of data to a new physical address, would render it's indexes unoperational
To avoid this issue, indexes in reclaimable storage tablespace have a changed format
• Index keys in reclaimable storage tablespaces point to data rows via logical (table-relative) addresses
• Consider using the ADMIN_MOVE_TABLE() stored procedure to move tables to new reclaimable storage tablespaces while maximizing table availability
ALTER TABLESPACE <tsname> REDUCE STOP
then later, at a more convenient time,
ALTER TABLESPACE <tsname> REDUCE MAX
<From DB2 Architecture for DBAs>