16.10 - Database Factors - Access Module

Teradata Tools and Utilities Access Module Reference

prodname
Access Module
vrm_release
16.10
created_date
July 2017
category
Programming Reference
featnum
B035-2425-077K
When using the access module products, consider the following database factors, which might improve performance:
  • Use the fastest Teradata client load or export utility that meets the requirements. For example, if a new (initially empty) table is being loaded, it is faster to use Teradata FastLoad than TPump. See Database Administration (B035-1093) for additional information about selecting the appropriate Teradata utility.
  • Use the appropriate number of sessions to the Teradata Database. Using multiple sessions in parallel can provide higher throughput.
  • Use fast, dedicated networks to connect a data source and Teradata Database. Minimize other traffic on the connections consuming bandwidth.
  • Ensure that no other applications and services are running on your system while it is running a load job.