SEO

#1 (**permalink**) 02-26-2008, 09:59 AM

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

#2 (**permalink**) 02-26-2008, 09:59 AM

If it's in backup pending you need to back it up.

"Tomas Calvo" <tomascalvo@hotmail.com> wrote in message
news:e2fa73da.0307170407.43fdd42d@posting.google.c om...
> 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Help!!! Tablespace in backup pending state after delete