16.20 - TWB_EVENTS Operation Event Metadata - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

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