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