Tablespace in "Backup in Progress" state

[Brian Wong]

Hi,
I have interesting situation was wondering if anyone could help me
shed some light on.
I have a unix script that runs everynight performing an online backup
on a DB2 EEE database (single partitioned). One night the backup
failed because one of the tablespaces was in a load pending state due
to a failed load.

I manage to fix the tablespace in question and rerun the backup... and
it completed without any problems... but now I noticed that some of my
tablepaces have a tablespace state of "Backup in Progress" instead of
normal.

Is there any way to put these tablespaces back to normal state?
Besides the worst case scenario of dropping and recreating them.

Any help on this is greatly appreciated!!!

[Kelly D. Rodger]

Brian, sounds like you may have encountered a problem fixed by APAR...
hmmm... not sure... I could probably find if it you needed it.

Anyway, your symptom is familiar and I do know that we made some changes
in this area for FP8. I'd recommend installing the latest fixpack where
this is properly resolved, but you should find that deactivating the
database and then restarting it again clears this particular state.

Hope that helps.
kdr

Brian Wong wrote:

> I have a unix script that runs everynight performing an online backup
> on a DB2 EEE database (single partitioned). One night the backup
> failed because one of the tablespaces was in a load pending state due
> to a failed load.
>
> I manage to fix the tablespace in question and rerun the backup... and
> it completed without any problems... but now I noticed that some of my
> tablepaces have a tablespace state of "Backup in Progress" instead of
> normal.
>
> Is there any way to put these tablespaces back to normal state?
> Besides the worst case scenario of dropping and recreating them.

--
------------------------------------------------------------------
Kelly D. Rodger IBM Canada
DB2 UDB Backup and Recovery Toronto Lab
------------------------------------------------------------------