Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Geting the database name by using SQL which is locked by a failed backup job
From:   Coffing Christopher L


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023