All Forums Database
monisiqbal 119 posts Joined 07/09
18 May 2010
Does the column AwtInUseMax from ResUsageSpma provide aggregated value for all the AMPs in the Node?

In ResUsageSpma data is reported per node. The definition of column AwtInUseMax is given as:

Peak number of AWTs (Max) on this node. This
is not the Peak or the Max value stored in the
Priority Scheduler (sch) data structure and
reported by the puma utility. The sch peak value
is the Max value since startup is never set and
Max is the maximum allowed value.

We don't know if this gives us the maximum AWT count from all the AMPs in the node
OR
sum of maximum AWT count from all AMPs

I'm asking this because we are thinking of dividing the AwtInUseMax by the number of AMPs in the node i.e. AwtInUseMax/Vproc1. Is it right to divide by the number of AMPs to determine the maximum AWT usage per node per AMP?

Can anyone please confirm?

monisiqbal 119 posts Joined 07/09
23 May 2010

Got the answer from a follow up on Carrie's blog post.
http://developer.teradata.com/blog/carrie/2009/09/more-on-resusagesawt-when-collection-and-logging-rates-differ

AwtInUseMax gives us the value representing the max AWT in-use count for ALL the AMPs in the node.

You must sign in to leave a comment.