Runtime Parameters
Table 12 describes the runtime parameters used by Teradata TPump on mainframe‑attached and network‑attached systems.
Mainframe‑attached |
Network‑attached |
Description |
BRIEF |
‑b |
Specifies reduced print output, which limits Teradata TPump printout to the minimal information required to determine the success of the job: |
BUFFERS = numberofbuffers |
‑f numberofbuffers |
Sets the number of request buffers Beginning with Teradata Tools and Utilities 06.02.00.01, the buffers runtime parameter can be set with a lower limit of 2 and no upper limit. The default value is 3. The maximum number of request buffers that may be allocated is BUFFERS * session_count. Beginning with Teradata Tools and Utilities 06.02.00.01, request buffers are a global resource, so buffers are assigned to any session as needed, and then returned to a free pool. At any point in time, the number of request buffers assigned to a session can vary from zero to BUFFERS * session_count. Prior to Teradata Tools and Utilities 06.02.00.01, a request buffer was permanently owned by the session to which it was first assigned, and so could not be used by any other session. The maximum number of requests buffers that a session could own was determined by the value of BUFFERS. |
CHARSET = |
‑c charactersetname |
Defines a character set for the Teradata TPump job |
|
|
The character set specification does not remain in effect if the client system fails, or if the Teradata TPump job is canceled. In these cases, when the job is resubmitted, the job must use the same character set specification that was used on the initial job. If a different character set specification is used when such a job is resubmitted, the data loaded by the restarted job will not appear the same as the data loaded by the initial job. |
|
|
If a character set specification is not entered, the default is whatever character set that is specified for Teradata Database when Teradata TPump was invoked. |
|
|
See Chapter 1: “Overview” for more information on supported character sets. When using a UTF‑16 client character set on the network or UTF‑8 client character set on the mainframe, specify the client character set name by the runtime parameter (that is, “‑c” on the network and “CHARSET” on the mainframe.) |
Not Applicable |
‑i scriptencoding |
Specifies the encoding form of the job script Valid encoding options are: The specified encoding character set applies to all script files included by the .RUN FILE commands. The UTF‑16 or UTF‑8 Byte Order Mark (BOM) can be present or absent in the script file. When UTF‑16 BOM is present and 'UTF‑16' is specified, Teradata TPump interprets the script according to the endianness indicated by the UTF‑16 BOM. When the UTF‑16 BOM is not present, Teradata TPump interprets the script according to the endianness indicated by the encoding option. |
Not Applicable |
‑u outputencoding |
Specifies the encoding form of the job output |
|
|
If is not placed ahead of other runtime parameters when invoking the job, a warning message will be printed. Available output encoding options are: UTF‑16BE instructs Teradata TPump to print the job output in big endian UTF‑16 encoding scheme. UTF‑LE instructs Teradata TPump to print the job output in little endian UTF‑16 encoding scheme. On big endian client systems, UTF‑16 instructs Teradata TPump to print the job output in big endian UTF‑16 encoding scheme. On little endian client systems, UTF‑16 instructs Teradata TPump to print the job output in little endian UTF‑16 encoding scheme. UTF‑16 BOM is printed as a part of job output for: |
CONFIG = filename |
‑C filename |
Specifies the configuration file for the Teradata TPump job The installation of Teradata TPump installs a default configuration file. On a UNIX system, it also installs a shell script that calls Teradata TPump using the default configuration file on the command line. The format of the entries in the file is: <keyword> <value> |
|
|
At this time, the only valid keyword is INMEMSORT, which is an integer data type containing the maximum number of bytes that can be sorted in memory. Teradata TPump recovery logic uses this value. This keyword can be modified to increase the amount of memory available for sorting. If this keyword is not provided in the configuration file, or the configuration file is not provided, the default value for INMEMSORT is 6,000,000 for a UNIX system, 12,000,000 for z/OS, and 3,000,000 for Windows. |
PRDICITY periodicityvalue |
‑d periodicityvalue |
Specifies to change the periodicity value to control the rate at which statements
are transferred to the database This parameter is in effect whenever the BEGIN LOAD command uses the RATE parameter to control the rate that statements are sent to the database. The default periodicity value is four 15‑second periods per minute. The periodicityvalue variable contains a value between 1 and 1500, which is the value range for the number of periods specified. The default value is 4. Alternatively, periodicity can be changed by executing the TPumpMacro.UserUpdateSelect macro (provided with Teradata TPump Monitor SQL scripts) to update the monitor interface table while the job is running. |
ERRLOG= |
‑e errorfilename |
Specifies to use the error logging function The errorfilename defined is the location where error messages are copied. Directory identifiers can also be included in the file names defined. On a UNIX system, the maximum length of the file name depends on the UNIX OS version currently in use. On mainframe‑attached client systems, the alternate file specification is limited to eight characters, and on z/OS, it must be to a DD name defined in the JCL. |
|
|
Note: If the file names defined already exist, they are overwritten. Otherwise, they are automatically created. There is no default error log errorfilename specification. |
MACROS |
‑m |
Invocation option to tell Teradata TPump to keep macros that were created during the
job run In order to use the same script after the ‑m parameter is used in the previous run, the EXECMACRO command must be added to the script. To avoid duplicate macro names, a random number from 1 to 99 is used in each macro name when the NAME command is not used. The format in which the macro is created is: MYYYYMMDD_HHMMSS_LLLLL_DDD_SSS
where |
RTYTIMES=nn |
‑t nn |
Specification for retry times The retry times options in the BEGIN LOAD can override this option for the requests/data sent between "BEGIN LOAD" and "END LOAD" pair. |
'tpump command' |
‑r 'tpump command' |
Invocation option that can signify the start of a Teradata TPump job '.RUN FILE tpump.script;'
|
VERBOSE |
‑v |
Specifies to turn on verbose mode In verbose mode, the input file from which statistics are normally displayed includes such additional statistics as the number of database requests sent, in addition to the normal number of requests. In verbose mode, Teradata TPump displays each retry-able error when it occurred. |
Not Applicable |
‑y |
Specification for the data encryption option The encryption options in the BEGIN LOAD or the PARTITION commands can override this option for the sessions associated with those commands |
Not Applicable |
< infilename |
Name of the standard input file containing the Teradata TPump commands and Teradata
SQL statements |
|
|
Note: On mainframe‑attached client systems, the DD control statement must be used to specify the input file before Teradata TPump is invoked. |
Not Applicable |
> outfilename |
Name of the standard output file for Teradata TPump messages |
|
|
Note: If an outfilename specification is used to redirect stdout, do not use the same outfilename as an output or echo destination in the DISPLAY or ROUTE commands. Doing so produces incomplete results because of the conflicting write operations to the same file. Note: On mainframe‑attached client systems, the DD control statement must be used to specify the output file before the utility is invoked. |
RVERSION |
‑V |
Display version number and stop. |
Note: See the invocation examples in Appendix B: “Teradata TPump Examples” for sample JCL listings, commands, and output samples for the invocation options.
Note: The first occurrence of the runtime parameter is in effect if the duplicates are specified. The remaining parameters will be omitted with a warning message “UTY1624 Warning: Run time parameters detected and omitted”.