15.00 - FastLoad Statistics - FastLoad

Teradata FastLoad Reference

prodname
FastLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2411-034K

FastLoad Statistics

Performance Statistics

Teradata FastLoad displays:

1) At the end of the Acquisition Phase
 
Acquisition Phase statistics:
Elapsed time: 00:07:43 (hh:mm:ss)
CPU time:     94.89 Second(s)
MB/sec:       41.19
MB/cpusec:    200.99
 
The abbreviation "MB/sec"'s longhand is megabytes (Total data FastLoad sends) per elapsed second.
 
The abbreviation "MB/cpusec"'s longhand is megabytes( Total data FastLoad sends) per cpu second.
 
2) At the end of the application phase:
 
Application Phase statistics:
Elapsed time: 00:02:43 (hh:mm:ss)
 
These performance statistics could be varied on different platforms.
 
An example of statistics output:
 
FastLoad displays at the end of Acquisition:
 
**** 11:53:09 Acquisition Phase statistics:
              Elapsed time: 00:00:13 (in hh:mm:ss)
              CPU time:     1.69 Seconds
              MB/sec:       4.25
              MB/cpusec:    32.68
 
FastLoad displays at the end of Application Phass:
 
**** 11:53:13 Application Phase statistics:
              Elapsed time: 00:00:04 (in hh:mm:ss)