17.00 - Writing Teradata TPump Job Scripts - Parallel Data Pump

Teradata® Parallel Data Pump Reference

Parallel Data Pump
June 2020
Programming Reference
A complete Teradata TPump job includes:
  • Invoking Teradata TPump
  • Logging onto the database and establishing the Teradata TPump support environment
  • Specifying the Teradata TPump tasks
  • Logging off from the 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

    See 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 the 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 the database and terminate Teradata TPump on the client system.