Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Feb 2009 @ 21:10:55 GMT


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


Subj:   Unix Script calling showlocks
 
From:   Ronald Montemayor

Is there a NON-Interactive unix command to call showlocks? We would like to call it from a script.

We do have several ARC processes, and they do sometimes fail and leave a lock on db or tables, We would like to run this script at certain times where we all assume that all arcs should be done.

We do have an alert policies implemented in TDMGR, but this alert is for a blocked SQL, and it's already too late to learn about the HUT/Locks. We want to catch them ahead.


Thanks!

Ron



     
  <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