TPT : tlogview Parameters and options

Tools

TPT : tlogview Parameters and options

Can someone help me with all the parameters and options available in tlogview command for reading TPT logs.
Tags (2)
6 REPLIES
Teradata Employee

Re: TPT : tlogview Parameters and options

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

Re: TPT : tlogview Parameters and options

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?

Teradata Employee

Re: TPT : tlogview Parameters and options

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

Re: TPT : tlogview Parameters and options

Sorry for the mistake,

I meant exactly what you said:)

Thanks.

Re: TPT : tlogview Parameters and options

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

Re: TPT : tlogview Parameters and options

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.