Task 3: Monitor and Manage a Teradata PT Easy Loader Job - Parallel Transporter

Task 3: Monitor and Manage a Teradata PT Easy Loader Job

You can monitor and manage a Teradata PT Easy Loader job just as you monitor and manage a Teradata PT job.

Teradata PT provides 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.

1 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.

2 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” on page 148 See also “Teradata PT Utility Commands” in Teradata Parallel Transporter Reference.

Procedure 2: View the Job Status

Do the following to check the status of a running job.

1 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: Terminate 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.

1 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.

2 When the job terminates, check the logs as shown in “Examine the Teradata PT Job Logs” below 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” on page 152. See also “Teradata PT Utility Commands” in Teradata Parallel Transporter Reference.