Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Mar 2009 @ 21:51:09 GMT


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


Subj:   Re: Check for Active LOCKS
 
From:   Diehl, Robert

Ronald,

Maybe if you include: how you are going to use this information? Then we can suggest better ways to see it. Also need to know how fast you need to react to the situation.

LOCKS can be found in LOCK LOGGER, but without real requirements I don't know if this is a valid solution. This is good to find locks/blocking after the fact.

Queries that are blocked can be found in Teradata Administrator/PMON and the API can be used depending on your requirements.

You can also use Teradata Alert Policies to send communications when a session is blocked for x amount of time.


Thanks,

Bob Diehl



     
  <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: 27 Dec 2016