Error limit in TPT's STREAM

[Naveen_K]

Hi All,

I want to capture rows skipped due to Errors from STREAM operator. I see that this is not captured in STREAM in the way it is done for LOAD. I just get the following message.

STREAM_OPERATOR: Rows Inserted: 285

STREAM_OPERATOR: entering Cleanup Phase

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 286, Total Rows Sent = 0

TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 0, Total Rows Sent = 286

However in Load operator, I get following message clearly indicating the rows that erred out.

LOAD_OPERATOR: Total Rows in Error Table 1:   0

LOAD_OPERATOR: Total Rows in Error Table 2:   0

LOAD_OPERATOR: Total Duplicate Rows:          0

Could you please let me know if there is such an option in STREAM operator? I'm using TTU 14.10.00.10.

[feinholz]

Starting in 15.00, the Stream operator will output the same stats for the error table to the console output, similar to what is done for the Load and Update operators.

The information is always available in the Stream operator private log.