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