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
15.00
Published
March 2014
Language
English (United States)
Last Update
2018-09-28
dita:mapPath
PDF_Installation_ZOS_15_00.ditamap/B035-3128-035K.ditamap
dita:ditavalPath
ft:empty
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 “Tuning TDP Cells to Optimize Performance” and related sections of the “Performance Measurement and Tuning” 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.