AWT

UDA

AWT

What is the best way to query for Amp Worker Tasks. (per amp)
I'm trying to identify what are the amps that are running out of AWT.

I'm greatful for any help.
4 REPLIES
ac
Enthusiast

Re: AWT

Hi Uncle Steve

I'm not aware of any way to query AWT info. You'll more than likely need to run the puma command on the nodes themselves to get this information. You could p**** the output and load a table with it so it was available for query analysis.

Cheers,

Andy

Re: AWT

Another way is to use AWTMON if you are on v2r6.
Enthusiast

Re: AWT

I believe V2R7 will have AWT information available in Teradata manager.
Stay tuned!!

Vinay
Teradata Employee

Re: AWT

Old thread, but I was looking for this info and found it on TD Developer Exchange here:

http://developer.teradata.com/blog/carrie/2009/09/more-on-resusagesawt-when-collection-and-logging-rates-differ