15.10 - Example: TWB_STATUS Performance and Statistical Metadata - Parallel Transporter

Teradata Parallel Transporter User Guide

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

Example: TWB_STATUS Performance and Statistical Metadata

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)
);