Second Output File - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-02-14
dita:mapPath
ybx1527114222321.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities
     ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 16.20.00.00               =
     =          PLATFORM LINUX                                         =
     =          PID      17444                                         =
     =                                                                 =
     ===================================================================

     ===================================================================
     =                                                                 =
     =          Copyright 1984-2017, Teradata Corporation.             =
     =          ALL RIGHTS RESERVED.                                   =
     =                                                                 =
     ===================================================================

**** 02:52:06 Processing starting at: Wed Sep 20 02:52:06 2017

     ===================================================================
     =                                                                 =
     =          Logon/Connection                                       =
     =                                                                 =
     ===================================================================

0001 .LOGON NODEID/fluser,

**** 02:52:06 Teradata Database Release: 16.20.00.00
**** 02:52:06 Teradata Database Version: 16.20.00.00
**** 02:52:06 Number of AMPs available: 4
**** 02:52:06 Current CLI or RDBMS allows maximum row size: 64K
**** 02:52:06 Character set for this job: ASCII

0002 BEGIN LOADING FL0161 ERRORFILES FL0161e1,FL0161e2;

**** 02:52:07 Session count 4 returned by the DBS overrides
              user-requested session count
**** 02:52:08 Number of FastLoad sessions connected = 4
**** 02:52:08 FDL4808 LOGON successful
**** 02:52:08 FastLoad is continuing a multifile job
**** 02:52:08 Number of AMPs available: 4
**** 02:52:08 BEGIN LOADING COMPLETE

0003 DEFINE c1 (integer), c2 (char(10)), c3 (varchar(3)) FILE=INDAT25;

**** 02:52:08 FDL4803 DEFINE statement processed

0004 RECORD 10 thru 15;

**** 02:52:08 Starting record number set to  : 10
**** 02:52:08 Ending record number set to    : 15

     ===================================================================
     =                                                                 =
     =          Insert Phase                                           =
     =                                                                 =
     ===================================================================

0005 INSERT INTO FL0161 (c1,c2,c3) VALUES (:c1,:c2,:c3);

**** 02:52:08 Number of recs/msg: 2920
**** 02:52:08 Starting to send to RDBMS with record 10
**** 02:52:08 Sending row 15
**** 02:52:08 Finished sending rows to the RDBMS

**** 02:52:08 Acquisition Phase statistics:
              Elapsed time: 00:00:00 (in hh:mm:ss)
              CPU time:     0 Seconds
              MB/sec:       N/A
              MB/cpusec:    N/A

0006 LOGOFF;

     ===================================================================
     =                                                                 =
     =          Logoff/Disconnect                                      =
     =                                                                 =
     ===================================================================

**** 02:52:08 Logging off all sessions
**** 02:52:09 Total processor time used = '1.04 Seconds'
     .        Start : Wed Sep 20 02:52:06 2017
     .        End   : Wed Sep 20 02:52:09 2017
     .        Highest return code encountered = '4'.
**** 02:52:09 FastLoad Paused