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.