Example: How to Analyze Cell Usage Optimization - 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

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.