Teradata TPump Configuration File

Teradata Parallel Data Pump Reference

brand
Teradata Tools and Utilities
prodname
Parallel Data Pump
vrm_release
15.00
category
Programming Reference
featnum
B035-3021-034K

Teradata TPump Configuration File

Configuration File Name and Location

On network-attached systems, the Teradata TPump configuration file must be named tpumpcfg.dat and it must be located in either:

  • The directory from which Teradata TPump was launched
  • or

  • The directory specified in the TPUMPLIB environment variable
  • On mainframe-attached systems, the DD statement for the Teradata TPump configuration file must be labeled TPUMPCFG.

    Configuration File Contents

    The Teradata TPump configuration file has the following entries:

    ARRAYSUPPORT=on
    RETRYFIRSTCONNECT=n
    RETRYOTHERCONNECT=n
    RETRYCONNECTINTERVAL=s

    Note: RETRYFIRSTCONNECT, RETRYOTHERCONNECT and RETRYCONNECTINTERVAL can only be specified in the configuration file for network‑attached platforms. There are no corresponding command line options.

    where

  • on for ARRAYSUPPORT turns on Array Support for the TPump job when there is no mention of the Array Support option in the TPump script.
  • n specified for RETRYFIRSTCONNECT is the maximum number of connection retries when TPump attempts to connect to the database the first time to SQL main session and it receives the CLI 207 error returned. The default value is 0.
  • n specified for RETRYOTHERCONNECT is the maximum number of connection retries when TPump attempts to connect to the database the other connections and it receives the CLI 207 error returned. The default value is 16.
  • s specified for RETRYCONNECTINTERVAL is the interval in seconds between retries. The default value is 60.