Archives of the TeradataForum

Message Posted: Thu, 06 Jan 2005 @ 19:07:05 GMT

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

Akleema

I remember trying to do a few things like this to support our EDW.

There is no sure fire way of doing this in SQL. Teradata Manager, ETL solutions or custom code are your choices.

Using bteq and Arcmain return codes is probably the way to go.

Sometimes we try to come up with solutions that fit only in our realm of control. This solution needs to be part of the process for each load. Capture the return codes and resolve the locks.

If the job fails as part of a BTEQ script you should be able to handle this exception and release the lock. The other option is to release the lock after success or failure of the backup routine. Teradata Manager can monitor the system and send alerts for BLOCKS or IDLE sessions etc... that can alert you when something is happening in the system that needs attention.

I have seen some good suggestions coming from the A-Team on the list but none of these provide a clean solution using SQL.

Take it from some of the best in the business (and I am NOT referring to me!)there is not a SQL answer to this one at this time.

Now of course after saying this, someone will prove me wrong... But that is what the Forum is all about.

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead DBA Operations & Support
Teradata Certified Master

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