Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Feb 2005 @ 14:30:10 GMT


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


Subj:   Monitoring Deadlocks
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, February 16, 2005 09:25 -->

Hi,

We are experiencing a lot of problems on our system with Deadlocks, however, because our jobs do not fail for Deadlocks (nor do we want them to!) we have been oblivious to the issue until now! (But on investigation, it turns out it is a regular occurence on our system).

We would like to set up a job to check on a daily basis if there have been deadlocks vernight, so that we can address the root cause.

One means of doing this would be to scan our job output logs on Unix and search for deadlock', however, I'm wondering is there anywhere on Teradata that the information is written to?? (Any DBC tables or anything??)


Thanks.



     
  <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