Procedure - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.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.