First Output File - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities
 ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 15.10.00.00              =
     =          PLATFORM WIN32                                         =
     =          PID      9612                                          =
     =                                                                 =
     ===================================================================
 
     ===================================================================
     =                                                                 =
     =          Copyright 1984-2015, Teradata Corporation.             =
     =          ALL RIGHTS RESERVED.                                   =
     =                                                                 =
     ===================================================================
 
**** 16:05:46 Processing starting at: Fri Jan 10 16:05:44 2014
 
0001 .SESSIONS 2;
 
**** 16:05:46 FDL4866 SESSIONS command accepted
 
     ===================================================================
     =                                                                 =
     =          Logon/Connection                                       =
     =                                                                 =
     ===================================================================
 
0002 .logon 10.25.32.40/fluser,
 
**** 16:05:48 Teradata Database Release: 15.10.00.00
**** 16:05:48 Teradata Database Version: 15.10.00.00
**** 16:05:49 Number of AMPs available: 4
**** 16:05:49 Current CLI or RDBMS allows maximum row size: 64K
**** 16:05:49 Character set for this job: ASCII
 
 
0003 .SHOW VERSION;
 
     FastLoad Version 15.10.00.00 for Win 32 running Windows Sockets
     FastLoad  : 15.10.00.02
     FastCmds  : 15.10.00.03
     FastIO    : 15.10.00.01
     FastMBCS  : 14.10.00.00
     FastNtfy  : 15.00.00.00
     FastPars  : 15.00.00.03
     FastSQL   : 15.00.00.03
     FastUtil  : 15.10.00.00
     Fdlosdep  : 13.01.00.00
     Teradata Data Connector  : 15.10e.00.00
     PMPROCS   : 15.10.00.01
     PMRWFMT   : 15.00.00.00
     PMTRCE    : 15.10.00.00
     PMMM      : 13.00.00.01
     PMUDDI    : 15.00.00.04
     DCUDDI    : 15.10.00.00
     PMHEXDMP  : 14.10.00.00
     PMUNXDSK  : 15.10.00.05
     ICUVER    : TDICU, 15.10d.00.00
     CLIV2     : 15.10.00.13
     MTDP      : 15.10.00.06
     MOSIos    : 15.10.00.01
     MOSIDEP   : 15.10.00.02
     OSENCRYPT : N/A
     OSERR     : 15.10.00.00
 
     FastLoad linking date: Dec 8 2014
 
 
 
0004 DROP TABLE FL0020e1;
 
**** 16:05:54 RDBMS error 3807: Object 'FL0020e1' does not exist.
 
0005 DROP TABLE FL0020e2;
 
**** 16:05:54 RDBMS error 3807: Object 'FL0020e2' does not exist.
 
 
0006 DROP TABLE FL0020;
 
**** 16:05:55 RDBMS error 3807: Object 'FL0020' does not exist.
 
0007 RECORD 1 THRU 10;
 
**** 16:05:55 Starting record number set to  : 1
**** 16:05:55 Ending record number set to    : 10
 
0008 create table FL0020
     (a int,
     b char(10));
 
**** 16:05:56 Command completed successfully
 
 
0009 DEFINE
     FIELD1 (integer),
     FIELD2 (char(10)),
     FILE=FDAT02;
 
**** 16:05:56 FDL4803 DEFINE statement processed
 
 
0010 BEGIN LOADING FL0020
     ERRORFILES FL0020e1,FL0020e2 checkpoint 100;
 
**** 16:05:57 Session count 4 returned by the DBS overrides
              user-requested session count
**** 16:06:03 Number of FastLoad sessions requested = 4
**** 16:06:03 Number of FastLoad sessions connected = 4
**** 16:06:03 FDL4808 LOGON successful
**** 16:06:05 Number of AMPs available: 4
**** 16:06:05 BEGIN LOADING COMPLETE
 
 
0011 SHOW;
 
     FILE = FDAT02
     FIELD1                           OFFSET =      0 LEN =     4 INTEGER
     FIELD2                           OFFSET =      4 LEN =    10 CHAR
     TOTAL RECORD LENGTH = 14
 
 
     ===================================================================
     =                                                                 =
     =          Insert Phase                                           =
     =                                                                 =
     ===================================================================
 
0012 INSERT INTO FL0020(A,B)
     VALUES (:field1,:FIELD2);
 
**** 16:06:07 Number of recs/msg: 3382
**** 16:06:07 Starting to send to RDBMS with record 1
**** 16:06:07 Sending row 10
**** 16:06:08 Finished sending rows to the RDBMS
 
**** 16:06:08 Acquisition Phase statistics:
              Elapsed time: 00:00:01 (in hh:mm:ss)
              CPU time:     0 Seconds
              MB/sec:       0.00
              MB/cpusec:    N/A
 
 
0013 LOGOFF;
 
     ===================================================================
     =                                                                 =
     =          Logoff/Disconnect                                      =
     =                                                                 =
     ===================================================================
 
**** 16:06:09 Logging off all sessions
**** 16:06:11 Total processor time used = '0.421203 Seconds'
     .        Start : Fri Jan 10 16:05:44 2014
     .        End   : Fri Jan 10 16:06:11 2014
     .        Highest return code encountered = '4'.
**** 16:06:11 FastLoad Paused