|
|
Archives of the TeradataForum
Message Posted: Thu, 06 Jan 2005 @ 13:35:33 GMT
Subj: | | Re: Geting the database name by using SQL which is locked by a failed backup job |
|
From: | | DycusR |
Hi,
I don't know how you are backing up your data, but using arcmain you can check your return code after the backup, and determine if a lock is in
place. If so, issue the command below -
RELEASE LOCK (databasename), ALL, OVERRIDE;
Or just issue the command by default - it won't hurt anything if there is not a lock in place.
Maybe this is an option for you.
| |