Archives of the TeradataForum

Message Posted: Thu, 18 Nov 2010 @ 08:20:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Naveen,

See if this works for you.

You could run a cron job every day before your critical jobs start which will release any left-over HUT locks from previous days backup.

You will have to include the databases which were backed up previous day in each script. So it would be like one script for each set of databases backed up each day.

When you run this script to release locks make sure that no other BAR jobs are running at that time.

If there aren't any HUT locks then the statement will just complete without doing anything (i.e. saying 0 rows processed)

Regards,

Abhishek Jadhav

	<Prev	Next>		<<First	<Prev	Next>	Last>>