Today I faced the following problem:
db2 "alter tablespace 12csdx resize (all 19067605)"
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1139N The total size of the table space is too big. SQLSTATE=54047
There are to option which you can take:
1. review the data stored in the tablespace,
2. convert the tablespace
If you decide to use the second option, use the following command:
db2 "ALTER TABLESPACE CONVERT TO LARGE"
* It can be applied only on regular DMS table spaces,
* You cannot convert a table space that contains a data partition of a partitioned table that has data partitions in another table space,
* Conversion cannot be reversed after being committed,