Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Performance Tuning and Sizing Guidelines for Informatica® Big Data Management 10.2.2

Performance Tuning and Sizing Guidelines for Informatica® Big Data Management 10.2.2

Performance Tuning and Sizing Guidelines for Informatica® Big Data Management 10.2.2

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!