Total number of AWTs

Database
Enthusiast

Total number of AWTs

How can I find the total number of AWTs that are configured for a system? 

3 REPLIES
Enthusiast

Re: Total number of AWTs

I think this is what you are looking for


In addition:

I think you have to see the settings for settings of AWT per amp, which is usually 80.Besides, you have  Work00, work type for query from dispatcher and Work01 for spawned query and other 24 reserved AWTs on each amp.

So my understanding is 

Number of AWTs per amp - Number of AWTs in std reserve pools + 3( Work00 + Work01) Which evaluates to

 80- 24 + 3(1 +1) .

This is usable amp worker task.

Cheers,

Raja

Teradata Employee

Re: Total number of AWTs

MaxAMPWorkerTasks in DBSCONTROL Internal fields provides what you are looking for.

Teradata Employee

Re: Total number of AWTs

Note that this is "per amp" number.  If you have tactical queries that access 1-2 amps only, they'll consume AWTs only on those AMPs.