View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 09:59 AM
Tomas Calvo
 
Posts: n/a
Default Help!!! Tablespace in backup pending state after delete

hi there!

While trying to issue a command to delete several rows from a table
and due to the big amount of registers I have obtained an error (I
suppose that the DB tries to save rollback info and it has no space).

After that I am having the following error while trying to
delete/update/insert in a table:

During SQL processing it returned:
SQL0290N Table space access is not allowed. SQLSTATE=55039

after type command "list tablespaces" I can see that the tablespace
that table belongs to is in "backup pending state".

I have tried to restore the tablespace to its normal state using the
command:

"QUIESCE TABLESPACES FOR TABLE...."

with no success and right now I have no idea of what to do...

Can anyone help me???

Thanks a lot

Tomas
Reply With Quote