All Forums Database
JustMe 76 posts Joined 03/07
09 Jun 2016
Unable to release locks

We are using DSA as our Backup and Restore option. 
Lately, we have had issues with the Restore portion on our DRT system.
We had a restore job that ran for several hours but seemed to make no progress.  The job was aborted.
Now, when trying to select from certain tables generates a 2654 error... Operation not allowed.  Table is being Restored.
However, SHOWLOCKS tells us that there are NO host utility locks on the system at all.l
 
Has anyone else experienced this?  What was the solution?

Fred 1096 posts Joined 08/04
09 Jun 2016

Either re-run and complete the restore or drop the tables.

JustMe 76 posts Joined 03/07
10 Jun 2016

Thanks Fred...

We will perform our quarterly refresh later this month, so I know that will take care of it.  Was just wondering if there was any other way.  
 
Thanks again!

Hustler 9 posts Joined 12/15
05 Jul 2016

Hi Fred/All
Please suggest me Regarding archive loggs:
Is there anyway we could run both FASTLOAD AND Backups parallely on the same objects?
         Trouble is DBC needs to take archive logg on the objects( during online backups) it supposed to backup; however if FASTLOAD is running a load job then it takes explicit archive log and then DBC skipping objects which lead to BACKUPS COMPLETED WITH ERROS. Is there anyway to go around this.
If Above is a NO,What if we make sure FASTLOAD is running exclusively after the Backup job? While backup job continues, if the FASTLOAD is kicked off; will it go to blocked state or fails?

Thanks,
Komal

You must sign in to leave a comment.