In general, the only ones you need are as follows:

tlogview -j -f

where:

is the unique identifier of the job (usually, the job name with a hyphen and unique number)

is the name of the operator-specific log you are interested in viewing

If you omit the private log name option, you generally just get the console output.

However, to make things easier, I like to tell people to do the following:

tlogview -j -f "*" -g

This will provide everything in the log (wildcard the private log name option), sorted according to which component/operator placed the messages in the lob (the -g option).

This will probably give you more than you need but is much simpler to remember.

Hi,

I have a doubt using tbuild -j jobid -w option,

My logfile is something like

W_1_op_loadjap_test: entering Application Phase
W_1_op_loadjap_test: Statistics for Target Table:  'vw186001.jap_test'
W_1_op_loadjap_test: Total Rows Sent To RDBMS:      2
W_1_op_loadjap_test: Total Rows Applied:            2
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 2, Total Rows Received = 0, Total Rows Sent = 0
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 0
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 1, Total Rows Received = 0, Total Rows Sent = 0
 

I want the logfile to filter on word"Total Rows" so that the output would look like,

W_1_op_loadjap_test: Total Rows Sent To RDBMS:      2
W_1_op_loadjap_test: Total Rows Applied:            2

Can anyone tell me how this can be done?

I think when you wrote this:

    I have a doubt using tbuild -j jobid -w option,

you meant this:

    I have a doubt using tlogview -j jobid -w option,

We do not offer the ability to filter based on keywords.

I am sure there are tools (like "grep" on Unix) to perform that type of filtering.

Sorry for the mistake,

I meant exactly what you said:)

Thanks.

I am trying load table with TPT 14( 14.00.00.04).
I am encountering following error,
W_0_op_loadPREM_DIM: TPT19417 pmRead failed. Buffer overflow (17)
W_0_op_loadPREM_DIM: TPT19305 Fatal error reading data.
TPT_INFRA: TPT02255: Message Buffers Sent/Received = 0, Total Rows Received = 0, Total Rows Sent = 0
W_0_op_loadPREM_DIM: TPT19221 Total files processed: 0.
While trying to load another table I am getting following error,
"TPT19003 Number of characters in column 6 (-1) exceeds maximum allowed (65536)"
Can you throw any light on this?
Let me know if any information is required from my side.
Vinay
 

Is this a load from a regular delimited file, named pipe or other producer operators ? Listing the tpt script would give some idea where the issue could be. 
Check schema definition and delimiters. Make sure the delimiter used is not there in any column data.