15.00 - Procedure for Writing a Script - Parallel Data Pump

Teradata Parallel Data Pump Reference

Parallel Data Pump
Programming Reference

Procedure for Writing a Script

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:

    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 Table 8.

    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 Table 8.

    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.

    Note: 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.