Teradata TPump Options Messages - 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

The options message lists the settings of some important Teradata TPump task parameters. A few examples follow:

Example 1

The following example depicts a typical options message.

**** 17:09:34 UTY6630 Options in effect for following TPump Import(s):
     .       Tenacity:    4 hour limit to successfully connect load sessions.
     .   Max Sessions:    10 session(s).
     .   Min Sessions:    8 session(s).
     .     Checkpoint:    10 minute(s).
     .       Errlimit:    1 rejected record(s).
     .   Restart Mode:    ROBUST.
     .  Serialization:    ON.
     .        Packing:    20 Statements per Request.
     .   StartUp Rate:    UNLIMITED Statements per Minute.

Example 2

In this example, the error limit is expressed as a percent of rows, not as a hard limit, the recovery mode is simple, and serialization is on.

**** 17:09:34 UTY6630 Options in effect for following TPump Import(s):
     .       Tenacity:    4 hour limit to successfully connect load sessions.
     .   Max Sessions:    4 session(s).
     .   Min Sessions:    4 session(s).
     .     Checkpoint:    5 minutes.
     .       Errlimit:    10% of records rejected.
     .   Restart Mode:    SIMPLE.
     .  Serialization:    ON.
     .        Packing:    20 Statements per Request.
     .   StartUp Rate:    500 Statements per Minute.

Example 3

In this example, there is no error limit in effect and tenacity has been set to zero.

**** 17:09:34 UTY6630 Options in effect for following TPump Import(s):
     .       Tenacity:    Sessions must successfully connect on first try.
     .   Max Sessions:    1 session(s).
     .   Min Sessions:    1 session(s).
     .     Checkpoint:    5 minutes.
     .       Errlimit:    No limit in effect.
     .   Restart Mode:    ROBUST.
     .  Serialization:    OFF.
     .        Packing:    40 Statements per Request.
     .   StartUp Rate:    UNLIMITED Statements per Minute.