Performance Statistics - FastExport

Teradata® FastExport Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastExport
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
jaa1691573250507.ditamap
dita:ditavalPath
gel1618411995444.ditaval
dita:id
rto1478610027076
Product Category
Teradata Tools and Utilities

Teradata FastExport now issues UTY8756 message at the end of each Retrieval Rows phase:

UTY8756 Retrieval Rows statistics:
        Elapsed time: 00:00:00:01 (dd:hh:mm:ss)
        CPU time:     xx.xx Seconds
        MB/sec:       xx.xx
        MB/cpusec:    xx.xx

The abbreviation MB/sec's longhand is megabytes (Total data Teradata FastExport receives) per elapsed second. The abbreviation MB/cpusec's longhand is megabytes (Total data Teradata FastExport receives) per cpu second.

This performance statistics could be varied on different platforms.

An example of statistics output:

**** 13:34:17 UTY8756 Retrieval Rows statistics
              Elapsed time:   00:00:49 (hh:mm:ss)
              CPU time:       1.66 Seconds
              MB/sec:         1.13
              MB/cpusec:      33.27]