Example: How to Analyze Cell Usage Optimization - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
bvb1608578422774.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
Product Category
Teradata Tools and Utilities

For the purpose of this example, assume the following things:

  • A system with 8 CPs, 8 SPs and 100 AMPs
  • 5 FastLoads running using 100 sessions
  • 5 BulkLoads running using 100 sessions
  • Each FastLoad or BulkLoad request is 32K (this produces approximately 33 992 byte cells, for a total of 31 Mbytes)
  • System is running with the default initial cell values, resulting in a TDP0021 message indicating exhaustion of 992 byte cells or a TDP0202 message indicating exhaustion of XMS cells.
  • 10% of the sessions have requests in transit through TDP simultaneously at any given moment.