View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 04:13 AM
randi_clausen@ins.state.il.us
 
Posts: n/a
Default SQL0289 when Alter table space

I am trying to resize a DMS tablespace container in a database.
There is only one table in this tablespace and it is at 89% full
currently. The command executes successfully but still the size
doesn't change (trying both through the alter TS GUI screen and typing
the alter command in the Command Center).
I read in this group that I needed to perform a reorg on the table for
the change to take effect--that is when I get the 289 error. So I
tried to add an additional container but that didn't work either as I
got the SQL0289 error again. What is the problem?

I have plenty of disk space (75.7 gb). Using WSE DB2 v8.1 FP5 on Win2K.

Reply With Quote