15.10 - TWB_EVENTS Operation Event Metadata - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

TWB_EVENTS Operation Event Metadata

Job event metadata are stored in the Teradata PT private log called TWB_EVENTS. These metadata provide timely and granular operational information, which includes event detection and notification at different levels and stages of Teradata PT jobs. Event data can be used to perform event analysis, enabling you to streamline and automate as many of the operational procedures as possible. Some examples of event metadata include:

  • Rows processed since job start
  • Rows processed since the last checkpoint
  • Rows checkpointed since job start
  • Rows applied to the target tables
  • CPU time used by each operator since job start
  • Elapsed time since job start (how long it has been running)
  • Start and End of data acquisition and data application phases
  • Start and end of a job
  • Job step that has finished execution or encountered an error
  • Storage fragmentation has reached a high-water mark
  • Shared memory usage has reached a high-water mark
  • Job termination request received from user