TWB_EVENTS Operation Event Metadata - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

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