db2 v9.7 DPF数据库缩小表空间（容器类型为file, 表空间类型为DMS）

2. 缩小表空间
db2 ALTER TABLESPACE TBS32SGLODSRSK LOWER HIGH WATER MARK
db2 "ALTER TABLESPACE TBS32SGLODSRSK REDUCE (ALL CONTAINERS 25 G)"

db2 ALTER TABLESPACE TBS32SGLODSLJP LOWER HIGH WATER MARK
db2 "ALTER TABLESPACE TBS32SGLODSLJP REDUCE (ALL CONTAINERS 80 G)"

db2 ALTER TABLESPACE TBS32SGLODSCON LOWER HIGH WATER MARK
db2 "ALTER TABLESPACE TBS32SGLODSCON REDUCE (ALL CONTAINERS 67 G)"

db2 ALTER TABLESPACE TBS32SGLODSACT LOWER HIGH WATER MARK
db2 "ALTER TABLESPACE TBS32SGLODSACT REDUCE (ALL CONTAINERS 313 G)"

db2 ALTER TABLESPACE TBS32SGLODSCRM LOWER HIGH WATER MARK
db2 "ALTER TABLESPACE TBS32SGLODSCRM REDUCE (ALL CONTAINERS 95 G)"

db2 ALTER TABLESPACE TBS32SGLODSTRD LOWER HIGH WATER MARK
db2 "ALTER TABLESPACE TBS32SGLODSTRD REDUCE (ALL CONTAINERS 365 G)"

[db2inst1@testdb1 ~]$ db2 "ALTER TABLESPACE TBS32SGLODSTRD REDUCE (ALL CONTAINERS 365 G)"
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL20170N  There is not enough space in the table space "TBS32SGLODSTRD" for
the specified action. Reason code = "1".  SQLSTATE=57059
[db2inst1@testdb1 ~]$ db2 list tablespaces show detail|grep State|grep 0x8
 State                                = 0x80000

这里执行完 db2 ALTER TABLESPACE TBS32SGLODSTRD LOWER HIGH WATER MARK 这个命令后，需要过一段时间直到表空间状态由0x80000变成0x00000后才可以继续执行
db2 "ALTER TABLESPACE TBS32SGLODSTRD REDUCE (ALL CONTAINERS 365 G)" 这个命令。