Tuning TDP Cells to Optimize Performance - Teradata Tools and Utilities

Teradata® Tools and Utilities for IBM z/OS Installation Guide

Product
Teradata Tools and Utilities
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-03-07
dita:mapPath
ovw1527114222335.ditamap
dita:ditavalPath
ovw1527114222335.ditaval
dita:id
B035-3128
lifecycle
previous
Product Category
Teradata Tools and Utilities
As installed, the TDP memory system is tuned for a very small workload. If the production workload greatly exceeds the level for which TDP is prepared, it may come to a complete stop. This may require that TDP be shut down and restarted to re-establish communication with the Teradata Database server.

For more information on tuning, refer to the General Tuning Options section of the Performance Measurement chapter in Teradata® Director Program Reference (B035-2416).

  1. Within a few hours of the initial start of the production Teradata workload on the IBM System z mainframe, collect TDP Cells data and perform the first tuning procedure.
  2. Within a few days, perform the tuning procedure again.
  3. Continue to periodically check the TDP Cells data to determine if the workload has changed and the tuning procedure is required again.