Procedure - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
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.