Procedure for Writing a Script - Parallel Data Pump

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.