15.00 - Third Output File - FastLoad

Teradata FastLoad Reference

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

Third Output File

 ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 15.00.00.000              =
     =          PLATFORM WIN32                                         =
     =          PID      460                                           =
     =                                                                 =
     ===================================================================
 
     ===================================================================
     =                                                                 =
     =          Copyright 1984-2014, Teradata Corporation.             =
     =          ALL RIGHTS RESERVED.                                   =
     =                                                                 =
     ===================================================================
 
**** 16:11:20 Processing starting at: Fri Jan 10 16:11:20 2014
 
0001 .SESSIONS 10;
 
**** 16:11:20 FDL4866 SESSIONS command accepted
 
     ===================================================================
     =                                                                 =
     =          Logon/Connection                                       =
     =                                                                 =
     ===================================================================
 
0002 .logon 10.25.32.40/fluser,
 
**** 16:11:22 Teradata Database Release: 15.00.00.00
**** 16:11:22 Teradata Database Version: 15.00.00.00
**** 16:11:22 Number of AMPs available: 4
**** 16:11:22 Current CLI or RDBMS allows maximum row size: 64K
**** 16:11:22 Character set for this job: ASCII
 
 
0003 .SHOW VERSION;
 
     FastLoad Version 15.00.00.00 for Win 32 running Windows Sockets
     FastLoad  : 15.00.00.02
     FastCmds  : 15.00.00.04
     FastIO    : 15.00.00.00
     FastMBCS  : 14.10.00.00
     FastNtfy  : 15.00.00.00
     FastPars  : 15.00.00.03
     FastSQL   : 15.00.00.03
     FastUtil  : 15.00.00.04
     Fdlosdep  : 13.01.00.00
     Teradata Data Connector  : 15.00.00.00
     PMPROCS   : 15.00.00.09
     PMRWFMT   : 15.00.00.00
     PMTRCE    : 13.10.00.02
     PMMM      : 13.00.00.01
     PMUDDI    : 15.00.00.02
     DCUDDI    : 15.00.00.09
     PMHEXDMP  : 14.10.00.00
     PMUNXDSK  : 15.00.00.05
     ICUVER    : TDICU, 15.00.00.00
     CLIV2     : 15.00.00.05
     MTDP      : 15.00.00.04
     MOSIos    : 14.10.00.09
     MOSIDEP   : 14.10.00.06
     OSENCRYPT : N/A
     OSERR     : 14.00.00.00
 
     FastLoad linking date: Dec 23 2013
 
 
 
0004 DROP TABLE FL0020e1;
 
**** 16:11:26 Command completed successfully
 
0005 DROP TABLE FL0020e2;
 
**** 16:11:26 Command completed successfully
 
 
0006 DROP TABLE FL0020;
 
**** 16:11:27 Command completed successfully
 
0007 RECORD 201 THRU 210;
 
**** 16:11:27 Starting record number set to  : 201
**** 16:11:27 Ending record number set to    : 210
 
0008 create table FL0020
     (a int,
     b char(10));
 
**** 16:11:27 Command completed successfully
 
 
0009 DEFINE
     FIELD1 (integer),
     FIELD2 (char(10)),
     FILE=FDAT02;
 
**** 16:11:27 FDL4803 DEFINE statement processed
 
 
0010 BEGIN LOADING FL0020
     ERRORFILES FL0020e1,FL0020e2 checkpoint 100;
 
**** 16:11:28 Session count 4 returned by the DBS overrides
              user-requested session count
**** 16:11:33 Number of FastLoad sessions requested = 4
**** 16:11:33 Number of FastLoad sessions connected = 4
**** 16:11:33 FDL4808 LOGON successful
**** 16:11:35 Number of AMPs available: 4
**** 16:11:35 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:11:37 Number of recs/msg: 3382
**** 16:11:37 Starting to send to RDBMS with record 201
**** 16:11:37 Sending row 210
**** 16:11:38 Finished sending rows to the RDBMS
 
**** 16:11:38 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 show;
 
     FILE = FDAT02
     FIELD1                           OFFSET =      0 LEN =     4 INTEGER
     FIELD2                           OFFSET =      4 LEN =    10 CHAR
     TOTAL RECORD LENGTH = 14
 
     ===================================================================
     =                                                                 =
     =          End Loading Phase                                      =
     =                                                                 =
     ===================================================================
 
0014 end loading;
 
**** 16:11:40 END LOADING COMPLETE
 
     Total Records Read              =  210
      - skipped by RECORD command    =  200
      - sent to the RDBMS            =  10
     Total Error Table 1             =  0  ---- Table has been dropped
     Total Error Table 2             =  0  ---- Table has been dropped
     Total Inserts Applied           =  10
     Total Duplicate Rows            =  0
 
     Start:   Fri Jan 10 16:11:39 2014
     End  :   Fri Jan 10 16:11:40 2014
 
**** 16:11:40 Application Phase statistics:
              Elapsed time: 00:00:01 (in hh:mm:ss)
 
0015 LOGOFF;
 
     ===================================================================
     =                                                                 =
     =          Logoff/Disconnect                                      =
     =                                                                 =
     ===================================================================
 
**** 16:11:42 Logging off all sessions
**** 16:11:45 Total processor time used = '0.358802 Seconds'
     .        Start : Fri Jan 10 16:11:20 2014
     .        End   : Fri Jan 10 16:11:45 2014
     .        Highest return code encountered = '0'.
**** 16:11:45 FDL4818 FastLoad Terminated