15.10 - Viewing Metadata - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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.