DB2 Database/Tablespace Size Debugging

It is one of the most fundamental laws in nature that, no matter what you computed with whatever nifty usage statistics in your upset mind at the beginning of a project, database space will become sparse.

In order to find out what the actual settings of the relevant tablespaces are, you can issue a

list tablespaces show detail

command once you have the sufficient privileges. Note that, even if your tablespace was created using "autosize", there may be a maxsize limit which you better turn off with

alter tablespace blablabla maxsize none

once again under the precondition that you have the sufficient privileges.