Procedure - Teradata Director Program

Teradata Director Program Reference

Product
Teradata Director Program
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
hwt1488824663348.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Follow this procedure to optimize cell usage.

  1. Issue an ADD CELLS command to bring the 992 byte cells up to a total of 3300.
  2. Run the workload again (5 FastLoads and 5 BulkLoads).
  3. Issue a D CELLS command at regular intervals to determine the number of available and in use cells.
  4. Use the results of the D CELLS query as follows.
    IF . . . THEN . . .
    the system is still at 100% utilization add more cells.
    cells are always available reduce the number of cells.

    Remember to aim for slightly more than average, not for the peak.