Monitoring and Managing a Teradata PT Easy Loader Job - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
vyv1488824663502.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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

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.

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

  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.

See also “Teradata PT Utility Commands” in Teradata Parallel Transporter Reference (B035-2436).