All Forums Tools
Amit Bhat 5 posts Joined 08/10
03 Aug 2010
TPT : tlogview Parameters and options

Can someone help me with all the parameters and options available in tlogview command for reading TPT logs.

feinholz 1234 posts Joined 05/08
06 Aug 2010

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.

--SteveF

vinaywani 10 posts Joined 11/11
27 Jul 2012

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?

 

 

 

feinholz 1234 posts Joined 05/08
27 Jul 2012

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.

 

--SteveF

vinaywani 10 posts Joined 11/11
29 Jul 2012

Sorry for the mistake,

I meant exactly what you said:)

Thanks.

vinaywani 10 posts Joined 11/11
03 Oct 2012

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
 

sureshvasu 4 posts Joined 02/12
03 Oct 2012

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.

You must sign in to leave a comment.