Hello,
A DB2 v. 8 DMS tablespace ran full. Subsequently, almost all data in the
tablespace has been deleted, but "LIST TABLESPACES SHOW DETAIL" keeps
stating that the tablespace has 0 free pages. I've tried running a REORG
on all remaining tables; that didn't help.
Trying to create a table in the tablespace yields:
bash-3.00$ db2 "create table foobar (x int not null) in s_problemspace"
DB21034E The command was processed as an SQL statement because it
was not a valid Command Line Processor command. During SQL processing
it returned:
SQL0289N Unable to allocate new pages in table space "S_PROBLEMSPACE".
SQLSTATE=57011
How can I make DB2 realize that there is plenty of space in the
tablespace?
"Dropped table recovery" is activated for the tablespace, by the way.
--
Regards,
Troels Arvin <tr****@arvin.dk>
http://troels.arvin.dk/