Writing Teradata TPump Job Scripts - 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
A complete Teradata TPump job includes:
  • Invoking Teradata TPump
  • Logging onto Teradata Database and establishing the Teradata TPump support environment
  • Specifying the Teradata TPump tasks
  • Logging off from Teradata Database and terminating Teradata TPump.

Use the following procedure as a guide for writing Teradata TPump job scripts:

  1. Invoke Teradata TPump, specifying the runtime options:
    • Normal or abbreviated (brief) printout

    • Number of buffers per session

    • Character set

    • Configuration file

    • Periodicity rate

    • Error logging function

    • Macro save option

    • Alternate run file

    • Verbose mode

    Refer to Invoking Teradata TPump for detailed information about how to specify these options.

  2. Establish the Teradata TPump support environment using the support commands summarized in the Teradata TPump Commands table in Teradata TPump Command Input.

    As a minimum, this part of the Teradata TPump job must include:

    • A LOGTABLE command to specify the restart log table

    • A LOGON command to provide a logon string that is used to connect all Teradata SQL and Teradata TPump utility sessions with Teradata Database.

  3. Specify the Teradata TPump task using the task commands summarized in the Teradata TPump Commands table in Teradata TPump Command Input.
  4. To specify another Teradata TPump task:
    • Use the support commands to modify the Teradata TPump support environment for the next task.

    • Use the task commands to specify the next task.

    Repeat these steps for each task in the Teradata TPump job.

    Though a single Teradata TPump job can include a number of different tasks, limiting the jobs to a single task for each invocation of Teradata TPump provides the highest assurance of a successful restart/recovery operation if a system failure interrupts the job.
  5. Use the LOGOFF command to disconnect all active sessions with Teradata Database and terminate Teradata TPump on the client system.