How to do it...

The following are the steps for resolving AWT saturation:

  1. Log on to viewpoint.
  2. Open the remote console portlet on viewpoint.
  3. Connect to any node using the ssh terminal.
  4. Execute puma -c to display the resource control information for each worktype in Vprocs. The information includes the minimum, maximum, currently in-use, and the peak number of AMP worker tasks assigned for each worktype:
puma -c
  1. With all default AMP numbers, if the total in-use count for the MSGWORKNEW and MSGWORKONE worktypes of a VPROC is = 62, it indicates a congested AMP. This means more new work is coming to the system and existing work is not getting completed. Can be seen in figure as INSUE column is at 62.
  1. Execute this command a couple of times ...

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.