vote up 1 vote down
star

The default number of AWTs per AMP is defined to be 80. Can this number grow to some larger value than 80 and can we set a threshold (of number of AWTs) on an AMP level or on Node or System level?

Additional note: ResUsageSpma and ResUsageSawt has AwtInuseMax but it does not give us the maximum defined number of AWTs.

flag

2 Answers

vote up 1 vote down

AMP Worker Tasks are configured and assigned during the system configuration. I don't think there is a dictionary table that will provide you that information. You may have to rely on one of the command line utilities to obtain that information or speak with your site's field engineer.

I believe the LimitAWT field you are seeing in the TDWM or TDMNGR tables are a result of defining a condition or system state that would trigger an event or an alert in the respective environment, Teradata Dynamic Workload Manager or Teradata Manager.

link|flag
but isn't PSA always running when TDWM is not running? – Monis Iqbal Dec 16 at 20:45
1 
 You are not always guaranteed to have a non-NULL value for the LimAWT column in PSAProfile. Priority Scheduler is always running even if you have not modified the default configuration. But the configuration settings made via schmon (including AWT Limit) are captured here. You should be able to find out the number of AWT that have been configured on your system from the DBA or Field Engineer. In nearly all instances I would expect this number to be 80 which is the default. I do not know what benefits would be gained by reducing this number, but there are always exceptions to the rule. – Rob Paller Dec 17 at 14:24
I agree with the non-NULL value in PSAProfile, but according to my understanding, PSA is always running when TDWM rules are disabled. Therefore, won't it be wrong for the PSA to have NULL values when it is enabled, what values will it be using then? or is my understanding about PSA wrong? – Monis Iqbal Dec 21 at 7:54
I think the PSAProfile is driven by the alerts configured in Teradata Manager. If you have access to configure Teradata Manager, try to configure an alert on the number of available AWT and see if this changes. I can try to do so on a Teradata Express on my laptop and see what happens. – Rob Paller Dec 22 at 15:02
vote up 0 vote down

I think the maximum number of AWTs can be determined by the

  1. AWT Limit defined in TDWM's PSA in 'System level parameters'? or
  2. In case of PSA the AWT Limit defined under the 'PD Set'?

If yes, then this information can be extracted from

  1. table: TDWM.PsfGlobalStates, column: LimitAWT
  2. table: TDMNGR.PSAProfile, column: LimitAWT
link|flag
Please confirm if this is true. – Monis Iqbal Dec 16 at 10:21

Your Answer

Get an OpenID
or

Not the answer you're looking for? Browse other questions tagged or ask your own question.