17.20 - First Output File - FastLoad

Teradata® FastLoad Reference - 17.20

Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-11
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval
     ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 17.20.00.02               =
     =          PLATFORM LINUX 64-bit                                  =
     =          PID      20452                                         =
     =                                                                 =
     ===================================================================

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

**** 02:50:02 Processing starting at: Fri May 20 02:50:02 2022	
     ===================================================================
     =                                                                 =
     =                         Logon/Connection                        =
     =                                                                 =
     ===================================================================
0001 .LOGON NODEID/fluser,
**** 02:50:02 Teradata Database Release: 17.20.00.00
**** 02:50:02 Teradata Database Version: 17.20.00.00
**** 02:50:02 Number of AMPs available: 4
**** 02:50:02 Current CLI or RDBMS allows maximum row size: 64K
**** 02:50:02 Character set for this job: ASCII

0002 DROP TABLE FL0161e1;
**** 02:50:02 RDBMS error 3807: Object 'FL0161e1' does not exist.

0003 DROP TABLE FL0161e2;
**** 02:50:02 RDBMS error 3807: Object 'FL0161e2' does not exist.

0004 DROP TABLE FL0161;
**** 02:50:03 Command completed successfully

0005 CREATE TABLE FL0161, FALLBACK(
     c1 integer,
     c2 char(10),
     c3 varchar(3))
     UNIQUE PRIMARY INDEX (c1);
**** 02:50:03 Command completed successfully

0006 BEGIN LOADING FL0161 ERRORFILES FL0161e1,FL0161e2;
**** 02:50:03 Session count 4 returned by the DBS overrides
     user-requested session count
**** 02:50:04 Number of FastLoad sessions connected = 4
**** 02:50:04 FDL4808 LOGON successful
**** 02:50:04 Number of AMPs available: 4
**** 02:50:04 BEGIN LOADING COMPLETE


0007 DEFINE c1 (integer), c2 (char(10)), c3 (varchar(3)) FILE=INDAT24;
**** 02:50:04 FDL4803 DEFINE statement processed

0008 SHOW;
FILE = INDAT24
C1                              OFFSET = 0  LEN = 4 INTEGER
C2                              OFFSET = 4  LEN = 10 CHAR
C3                              OFFSET = 14 LEN = 3 VARCHAR
TOTAL RECORD LENGTH = 19

    ===================================================================
    =                                                                 =
    =                    Insert Phase                                 =
    =                                                                 =  
    ===================================================================
0009 INSERT INTO FL0161 (c1,c2,c3) VALUES (:c1,:c2,:c3);
**** 02:50:04 Number of recs/msg: 2920
**** 02:50:04 Starting to send to RDBMS with record 1
**** 02:50:04 Sending row 9
**** 02:50:04 Finished sending rows to the RDBMS

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

0010 LOGOFF;
    ===================================================================
    =                                                                 =
    =                       Logoff/Disconnect                         =
    =                                                                 =
    ===================================================================
**** 02:50:04 Logging off all sessions
**** 02:50:04 Total processor time used = '0.94 Seconds'
     .      Start : Fri May 20 02:50:02 2022
     .      End   : Fri May 20 02:50:04 2022
     .      Highest return code encountered = '4'.
**** 02:50:04 FastLoad Paused