Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2009 @ 12:05:07 GMT

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

Subj:   Re: Unix Script calling showlocks
From:   Victor Sokovin

  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.  

Ron, you may consider running the check scripts from the central scheduling tool, if you have one. The advantage is that others are aware of the checks running at certain times and can prepare for possible positive or negative effects on other jobs running in parallel. Having one overview of all jobs running at a time is very convenient. Also, the checks themselves can fail, and somebody will need to be notified to address the issue etc. Management of all these bits and pieces becomes easier and more transparent if you use one tool for scheduling of all your jobs.


  <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