Archives of the TeradataForum

Message Posted: Tue, 08 Mar 2005 @ 14:38:06 GMT

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

If you have 3 Amps all doing work you will see the results you described.

One of the fields returned tells you how many Amps were active (did any work) during the current interval. (It is confusingly called UpAmpCount but it actually tells you how many Amps participated - not how many are online.)

If you only get a value for HotAmp1CPU that would imply that the system is very skewed and only that Amp did any work (so the AmpCount would be 1)

In this case I think the other fields would contain zeros. (Unless you have less than 3 Amps in the system - in which case some would be Null.)

Assuming you are using indicator mode it is always best to first check for a Null (and treat it as a zero value in this case) and then read the value.

Mike Dempsey
Teradata Client Tools

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