DB2降低高水位步骤:
1.降之前通过db2 list tablespaces show detail可以将可以释放的page但还没有标记为可释放的标记出来
db2_all "db2 connect to TKDM;db2 list tablespaces show detail;"
db2 "select tbsp_name,dbpartitionnum,tbsp_usable_pages,tbsp_used_pages,tbsp_free_pages,tbsp_pending_free_pages from sysibmadm.snaptbsp_part order by tbsp_pending_free_pages desc fetch first 20 rows only"
2.降高水位
db2 ALTER TABLESPACE DTA REDUCE MAX
db2 "SELECT MEMBER,varchar(TBSP_NAME, 20) AS TBSP_NAME, NUM_EXTENTS_MOVED, NUM_EXTENTS_LEFT, TOTAL_MOVE_TIME from TABLE(MON_GET_EXTENT_MOVEMENT_STATUS('DTA',-2)) AS t order by MEMBER"
3.停止降高水位
db2_all '<<+1< db2 connect to TKDM;db2 list tablespaces show detail' |grep -w -A12 DTA 看某个member的某个表空间的情况
db2 alter tablespace DTA lower high water mark stop 停降高水位