I have tablespaces set to auto resize with no maxsize. Probably when doing the reorg, db2 created shadow indexes in the same tablespace and the tablespace increased. The filesystem hit 100% and reorg failed with this error
SQL2216N SQL error "-968" occurred while reorganizing a database table or its indexes
Temp tablespace gets automatically released. When I took snapshot on the tablespace where the table resides, I see pending free pages. As per the documentation, a rollback or commit should release them. The database has been deactivated and activated. The filesystem still shows 100% and snapshot of the tablespace shows the same pending free pages.
Does this mean, even after reorg rollsback, db2 doesn't delete the indexes it created in the tablespace? How do I fix this, just increase the filesystem and redo the reorg?