Teradata TPump Configuration File - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-11
dita:mapPath
dmq1512702641516.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

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
RETRYFIRSTCONNECT, RETRYOTHERCONNECT and RETRYCONNECTINTERVAL can only be specified in the configuration file for network-attached platforms. There are no corresponding command line options.
where the following is true:
  • 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.