Teradata MultiLoad Configuration File - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
fel1608578437279.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use a Teradata MultiLoad configuration file to set the initial default values for the following operating parameters when invoking Teradata MultiLoad:
  • AMPCHECK
  • BRIEF
  • CALLINMODFORFINALCKP
  • CHARSET
  • CONFIGERRORS
  • DATAENCRYPTION=ON or OFF
  • ERRLOG
  • IFORMAT
  • OFORMAT
  • MATCHLEN
  • MAXSESS
  • MINSESS
  • RETRYCONNECTINTERVAL
  • RETRYFIRSTCONNECT
  • RETRYOTHERCONNECT
RETRYFIRSTCONNECT, RETRYOTHERCONNECT and RETRYCONNECTINTERVAL can only be specified in the configuration file for workstation-attached platforms. There are no corresponding command line options.

The values specified in the Teradata MultiLoad configuration file override the internal utility default values for these parameters.

The configuration file parameters can themselves be overridden by the corresponding run-time parameters, shown earlier. (There is no MATCHLEN run-time parameter.) The order of preference for these parameters, from highest to lowest, is:
  • 1 – Run-time parameters
  • 2 – Teradata MultiLoad script
  • 3 – Teradata MultiLoad configuration file specifications
  • 4 – Teradata MultiLoad default values

Configuration File Name and Location

On workstation-attached systems, the Teradata MultiLoad configuration file must be named mloadcfg.dat and it must be located in either:
  • The directory from which Teradata MultiLoad was launched

    or

  • The directory specified in the MLOADLIB environment variable

On mainframe-attached systems, the DD statement for the Teradata MultiLoad configuration file must be labeled MLOADCFG.

Configuration File Contents

The Teradata MultiLoad configuration file can have up to eleven entries, one for each parameter:

AMPCHECK = none/all/apply
none/all/apply for AMPCHECK configures the Teradata MultiLoad response to a down AMP condition, see Dealing with AMPS and BEGIN MLOAD and BEGIN DELETE MLOAD for more information.
BRIEF = on/off
on/off for BRIEF configures the reduced print output specification for the Teradata MultiLoad job.
CALLINMODFORFINALCKP = Y[es]/N[o]
This parameter calls INMOD for a final checkpoint of the Teradata MultiLoad job. Y[es] calls inmod for the final checkpoint. N[o] (default) prohibits MultiLoad from calling the final checkpoint with INMOD.
CHARSET=character-set-name
character-set-name is the character set specification for the Teradata MultiLoad job.
CONFIGERRORS=IGNORE/TERMINATE
IGNORE/TERMINATE configures the option for the Teradata MultiLoad configuration file error handling.
DATAENCRYPTION=on/off
on/off for DATAENCRYPTION specifies whether data encryption will be enabled for the Teradata MultiLoad job.
ERRLOG=filename
filename is the alternate file specification for Teradata MultiLoad error messages.
IFORMAT = scriptencoding
scriptencoding for IFORMAT is the character set specification for the job script file. This parameter can be used on workstation-attached systems only.
  • Valid values for UTF-16 are UTF16 and UTF-16
  • Valid values for UTF-16BE are UTF-16BE, UTF16-BE and UTF16BE
  • Valid values for UTF-16LE are UTF-16LE, UTF16-LE, and UTF16LE
  • When UTF-16 BOM is present and 'UTF-16' is specified, Teradata MultiLoad interprets the script according to the endianness indicated by the UTF-16 BOM. When the UTF-16 BOM is not present, Teradata MultiLoad interprets the script according to the endianness indicated by the encoding option.
OFORMAT = outputencoding
outputencoding for OFORMAT is the character set specification for the screen output. This parameter can be used on workstation-attached systems only.
  • Valid values for UTF-16 are UTF16 and UTF-16
  • Valid values for UTF-16BE are UTF-16BE, UTF16-BE and UTF16BE
  • Valid values for UTF-16LE are UTF-16LE, UTF16-LE, and UTF16LE
MATCHLEN=on/off
on/off for MATCHLEN configures the record length validation option for the Teradata MultiLoad job. When MATCHLEN is enabled, Teradata MultiLoad verifies that the record length of the import data is the same as the layout record length specified by the IMPORT command.
MAXSESS=max-sessions
max-sessions is the MAXSESS specification for the maximum number of Teradata MultiLoad sessions logged on to the database.
MINSESS=min-sessions
min-sessions is the MINSESS specification for the minimum number of Teradata MultiLoad sessions required to run the job.
RETRYCONNECTINTERVAL=s
s specified for RETRYCONNECTINTERVAL is the interval in seconds between retries. The default value is 60.
RETRYFIRSTCONNECT=n
n specified for RETRYFIRSTCONNECT is the maximum number of connection retries when MultiLoad 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.
RETRYOTHERCONNECT=n
n specified for RETRYOTHERCONNECT is the maximum number of connection retries when MultiLoad attempts to connect to the database the other connections and it receives the CLI 207 error returned. The default value is 16.

The Teradata MultiLoad configuration file can also have comment statements preceded by a number sign (#) character. For detailed descriptions of the specifications listed here, see Runtime Parameters.

Configuration File Processing

The utility automatically checks for a configuration file each time the invocation command is entered. Upon locating a configuration file, the utility sets the defaults as specified, produces the appropriate output messages, and begins processing the job.

By default, any invalid configuration file entry or syntax error will abort the Teradata MultiLoad job immediately. The first invalid parameter will be reported, the rest of the config parameters will not be checked.
  • If CONFIGERRORS=IGNORE is specified in the config file, any subsequent config file problems will be reported but not affect the Mload return code. Mload will continue to process the next entry in the config file utility.
  • If CONFIGERRORS=TERMINATE is specified in the config file, any subsequent invalid configuration file entry will abort the Teradata MultiLoad job.
The config file must be in the platform-appropriate single-byte character set, like ASCII or EBCDIC.