Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2008 @ 10:54:28 GMT


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


Subj:   Re: Validating Effectiveness of TDWM Query
 
From:   Vinay Bagare

I believe the query is throttled and what you want may to check is DelayTime field in DBC.Dbqlogtbl.

If you have PMCP data, then you could also look at SYS_MGMT or PMCP database table (DBQLogTbl_Hst).

If the DelayCount is greater than Zero, it means that the throttles are working.

Also make sure that the rule is enabled and active. Check PMON if you see the queries are in Delay queue.

Hope this helps.


Thanks,

Vinay Bagare



     
  <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