Viewing Metadata - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Viewing Metadata

Use the tlogview command to retrieve job performance and statistical metadata will be collected, 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 “Exporting and Loading Metadata” on page 255.