Performance Statistics - FastExport

Teradata FastExport Reference

Product
FastExport
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-22
dita:mapPath
fmk1488824663357.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2410
lifecycle
previous
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]