Viewing Metadata - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.00
Published
August 31, 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
zae1544831938751.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.