SQL2094W The rebalance of table space fails with Reason code: "3"

Question

Alter tablespace ts1 rebalance command failed with insufficient disk space.

During rebalance its occupy 200GB space and after rebalance fail, it does not release the space.

How this 200GB space to be released? DB2 version is 10.5.0.5

Answer 1

Alter tablespace ts1 reduce, release the free space.