Second Output File | Teradata FastLoad - Second Output File - FastLoad

Teradata® FastLoad Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval
dita:id
wzs1478610185776
Product Category
Teradata Tools and Utilities
     ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 17.20.00.04               =
     =          PLATFORM LINUX 64-bit                                  =
     =          PID      1264620                                       =
     =                                                                 =
     =          FASTLOAD UTILITY is DEPRECATED.                        =
     =          It is provided to run existing workloads created       =
     =          prior to 07-SEP-2023.                                  =
     =          Please use Teradata Parallel Transporter for           =
     =          workloads.                                             =
     =                                                                 =
     ===================================================================

     ===================================================================
     =                                                                 =
     =          Copyright 1984-2023 Teradata.                          =
     =          All rights reserved.                                   =
     =                                                                 =
     ===================================================================

**** 04:26:17 Processing starting at: Sun Sep 10 04:26:17 2023

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

0001 .LOGON NODEID/fluser,

**** 04:26:18 Teradata Database Release: 17.20.00.00
**** 04:26:18 Teradata Database Version: 17.20.00.00
**** 04:26:18 Number of AMPs available: 2
**** 04:26:18 Current CLI or RDBMS allows maximum row size: 64K
**** 04:26:18 Character set for this job: ASCII

0002 BEGIN LOADING FL0161 ERRORFILES FL0161e1,FL0161e2;

**** 04:26:19 Session count 2 returned by the DBS overrides
              user-requested session count
**** 04:26:19 Number of FastLoad sessions connected = 2
**** 04:26:19 FDL4808 LOGON successful
**** 04:26:19 FastLoad is continuing a multifile job
**** 04:26:19 Number of AMPs available: 2
**** 04:26:19 BEGIN LOADING COMPLETE

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

**** 04:26:19 FDL4803 DEFINE statement processed

0004 RECORD 10 thru 15;

**** 04:26:19 Starting record number set to  : 10
**** 04:26:19 Ending record number set to    : 15

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

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

**** 04:26:19 Number of recs/msg: 2920
**** 04:26:19 Starting to send to RDBMS with record 10
**** 04:26:19 Sending row 15
**** 04:26:19 Finished sending rows to the RDBMS

**** 04:26:19 Acquisition Phase statistics:
              Elapsed time: 00:00:00 (in hh:mm:ss)
              CPU time:     0.000233 Seconds
              MB/sec:       N/A
              MB/cpusec:    0.47

0006 LOGOFF;

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

**** 04:26:19 Logging off all sessions
**** 04:26:19 Total processor time used = '0.022553 Seconds'
     .        Start : Mon Aug  7 04:26:17 2023
     .        End   : Mon Aug  7 04:26:19 2023
     .        Highest return code encountered = '4'.
**** 04:26:19 FastLoad Paused