You can monitor and manage a Teradata PT Easy Loader job just as you monitor and manage a Teradata PT job.
Teradata PT offers the capability to monitor and manage a job while it is running.
- The twbcmd command allows you to:
- Pause and resume a job
- View the status of a job
- The twbkill command allows you to stop a job
Procedure 1: Pause and Resume a Job
Once a Teradata PT job launches, you can pause and then resume the job using the twbcmd command.
- From the command line in the working directory, enter the following command to pause the job:
twbcmd job_id JOB PAUSE
where job_id is the job name followed by a dash (“-”) and the job sequence number generated by the system at launch.
- When you are ready to continue, enter the following command to resume the job:
twbcmd job_id JOB RESUME
The job resumes at the point at which it was paused.
Reference Information
Information on... | Is available in... |
---|---|
the twbcmd command | Using the twbcmd Command to Monitor and Manage Job Performance See also “Teradata PT Utility Commands” in Teradata Parallel Transporter Reference (B035-2436). |
Procedure 2: Viewing the Job Status
Do the following to check the status of a running job.
- From the command line in the working directory, enter the following command to
check job
status:
twbcmd job_id JOB STATUS
where job_id is the job name followed by a dash (“-”) and the job sequence number generated by the system at launch.
Procedure 3: Terminating a Job
If you need to terminate a running job (if, for example, continuation of the job could either cause system failures or significantly impact overall system performance), you can use the twbkill command to force all executing job tasks to terminate immediately.
- From the command line in the working directory, enter the following command to terminate a job:
twbkill job_id
where job_id is the job name followed by a dash (“-”) and the job sequence number generated by the system at launch.
- When the job terminates, check the logs as shown in “Examine the Teradata PT Job Logs” to make sure you understand the problem that led to the job termination.
Reference Information
Information on... | Is available in... |
---|---|
the twbkill command | Using twbkill to Terminate a Job. See also “Teradata PT Utility Commands” in Teradata Parallel Transporter Reference (B035-2436). |