17.00 - Teradata TPump Options Messages - Parallel Data Pump

Teradata® Parallel Data Pump Reference

prodname
Parallel Data Pump
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-3021-220K

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.