Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Apr 2005 @ 13:38:25 GMT


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


Subj:   ResUsageSvpr - msgworkqlenmax & msgworkqlensum
 
From:   Mirjam Berger

A-Team,

I'm trying to find out why the DBC.ResUsageSvpr.msgworkqlensum value would be 0 when the DBC.ResUsageSvpr.msgworkqlenMax value is > 0.

The manual states:

MsgWorkQLenSum
count Total number of work requests waiting during each log interval.

MsgWorkQLenMax
track Maximum number of work requests waiting during each log interval.

(Source: Teradata® RDBMS, Resource Usage Macros and Tables, 7-11)


This sounds to me as if the Sum should always be equal to or bigger than the Max.

We are running on V2R5. Is the population of this field dependent on some setting? Is this maybe a known bug?

Your help would be much appreciated!!


Thanks!

Mirjam



     
  <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