Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 01 Jan 2002 @ 10:49:18 GMT


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


Subj:   Re: Teradata Priorities
 
From:   Dennis Calkins

Hi,

In Teradata v2r4.1, and TUF 6.1 there is also the opportunity to set up enforcement of Internal Business Rules using the Teradata Database Query Manager (TDQM).

This is the same application we had using ODBC, but in 4.1 we moved the rules processing inside the database so all queries regardless of where they come from can be blocked from running if they are estimated to use too many resources.

They will be aborted before they even start if they voilate any of your predefined rules.

Rules like....

User Sam can't run a query before 6:00 pm.

No user can run a query which is estimated to run longer than 5 minutes before 6:00 pm.

User george can't run a query which will user > 1 Gig of spool.

Now this relies on the parser and Optimizer plan estimates to make their determination about whether to abort or allow it to run.

I have seen estimates like it will take 20 minutes to run when in reality it takes 2 minutes, so care needs to be taken when defining your rules.



     
  <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