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.