Procedure - Director Program

Teradata Director Program Reference

Product
Director Program
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
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.