Example: TWB_STATUS Performance and Statistical 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
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

The data schema for the TWB_STATUS’ private log can be mapped to the following CREATE TABLE DDL statement:

create table Job_Status_Tbl
(
      Step_Name           varchar(21),
      Task_Name           varchar(21),
      Status_Message      varchar(21),
      Operator_Name       varchar(21),
      Instance_Count      varchar(5),
      Instance_Number     varchar(5),
      Status              varchar(21),
      Start_Time          varchar(9),
      Elapsed_Time        varchar(11),
      CPU_Time            varchar(11),
      Block_Size          varchar(11),
      Buffer_Count        varchar(11),
      Input_Rows          varchar(17),
      Output_Rows         varchar(17),
      Checkpoint_Interval varchar(6),
      Latency_Interval    varchar(6),
      End_of_Data         varchar(2),
      Multi_Phase         varchar(1)
);