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:
- 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.
- 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.
- Specify the Teradata TPump task using the task commands summarized in the "Teradata TPump Commands" table in Teradata TPump Command Input.
- 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. - Use the LOGOFF command to disconnect all active sessions with the database and terminate Teradata TPump on the client system.