Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Tuning and Sizing Guidelines for Data Engineering Integration (10.4.x)

Tuning and Sizing Guidelines for Data Engineering Integration (10.4.x)

Tuning and Sizing Guidelines for Data Engineering Integration (10.4.x)

TDCH for Sqoop Tuning Tips

TDCH for Sqoop Tuning Tips

Consider the following tuning tips for Sqoop TDCH:
  • If you use an IP address in the connection, all connections connect to a single server which can be a bottleneck.
  • COP stands for Communications Processor. COP Discovery refers to the process of performing multiple DNS lookups to identify all the Teradata Database nodes that the client software could potentially connect to. Using cop address allows connections to round-robin over cop servers to connect each mapper to a different node. For example:
    Teradatacop1 or teradatacop1.domain.com
    Teradatacop2 or teradatacop2.domain.com
    Teradatacop3 or teradatacop3.domain.com
  • Laddered Concurrent Connect (LCC) occurs second, and uses the two-dimensional array as the list of possible IP addresses to choose from. The purpose of LCC is to make multiple TCP socket connect attempts in parallel. LCC provides 3-4x faster throughput with parallel connections.

0 COMMENTS

We’d like to hear from you!