Unable to allocate new pages in table space "XXXX" ... but it's 250 megs and I'm only running DDL
- by Sylvia
Hello,
I'm a DB2 newbie, so I'd appreciate even any pointers on where to start looking. We have great DB2 admins but they're swamped with other issues now, so I'm trying to do some troubleshooting on a development database.
My situation is that I have a tablespace that's giving me this error message
Unable to allocate new pages in table space "[MyTableSpace]".
However, all I'm doing is running multiple (hundreds) of DDL statements, mainly creating tables but also indexes and pk scripts. So, considering that the tablespace has about 250 mg, I shouldn't be running out of space, right?
Here's another thing - it appears that after I leave my script for a while, something "resets" and works for a while, then I begin to have the tablespace issue again.
thanks,
Sylvia