Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 24 Mar 2006 @ 20:36:42 GMT


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


Subj:   Re: Abort a query if it exceeds time limit
 
From:   Ballinger, Carrie

Unfortunately, the basic workload management options today (TDQM, TDWM) that might provide some governing capability are based on NOT starting the query if the explain estimates suggest it will be a long-running query, rather than aborting it if it actaully exceeds a limit of time. Both TDQM and TDWM relinquish control over the query when it begins to execute.

The capability to abort a query after a specified amount of time has passed is included in TASM (Teradata Active System Management) functionality. By defining exception conditions on the workload definition that the query will be mapped to, you can specify that the query will be aborted, or moved to a different priority if you wish, based on elapsed time reaching a defined threshold.


Thanks, -Carrie



     
  <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