Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 27 Apr 2005 @ 20:56:30 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: ResUsageSvpr - msgworkqlenmax & msgworkqlensum
From:   Campbell, William Dennis

I saw the post asking about the definitions and values of ResUsageSvpr - msgworkqlenmax & msgworkqlensum. I agree, the text of the Resource Usage manual is a bit confusing.

The followig clarification comes from the Teradata engineer in charge of this feature:

"It is not a bug. The MsgWorkQLenSum sums the current counts captured at the end of each collect period. Since the current count can be zero when the data is collected, the sum can be 0. The max count, on the other hand, tracks the maximum value over the log period and therefore it can be non-zero even though the sum count is 0."

We will clarify the MsgWorkQLenSum description on the next document update.

Dennis Campbell
Teradata Information Engineering

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023