16.20 - Viewing Metadata - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval

Use the tlogview command to retrieve job performance and statistical metadata, as follows.

  • To access the TWB_STATUS log, enter the following:
    tlogview -l <user log file name> -f TWB_STATUS > <output file name>
  • To access the TWB_SRCTGT log, enter the following:
    tlogview -l <user log file name> -f TWB_SRCTGT > <output file name>
  • To access the TWB_EVENTS log, enter the following:
    tlogview -l <user log file name> -f TWB_EVENTS > <output file name>

where:

  • <user log file name> is the Teradata PT log file name, typically ending with an .out extension.
  • <output file name> is the user-supplied name of the file to receive the output from the command

After the performance data has been collected, you can load it into a set of relational tables so that queries against the data can be done with SQL. For example about how to load the TWB_STATUS log into a relational table, see Exporting and Loading Metadata.