15.00 - Second Output File - FastLoad

Teradata FastLoad Reference

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

Second Output File

 ===================================================================
    =                                                                 =
    =          FASTLOAD UTILITY     VERSION 15.00.00.000              =
    =          PLATFORM WIN32                                         =
    =          PID      6956                                          =
    =                                                                 =
    ===================================================================
 
    ===================================================================
    =                                                                 =
    =          Copyright 1984-2014, Teradata Corporation.             =
    =          ALL RIGHTS RESERVED.                                   =
    =                                                                 =
    ===================================================================
 
*** 16:09:00 Processing starting at: Fri Jan 10 16:08:59 2014
 
001 .SESSIONS 10;
 
*** 16:09:00 FDL4866 SESSIONS command accepted
 
    ===================================================================
    =                                                                 =
    =          Logon/Connection                                       =
    =                                                                 =
    ===================================================================
 
002 .logon 10.25.32.40/fluser,
 
*** 16:09:02 Teradata Database Release: 15.00.00.00
*** 16:09:02 Teradata Database Version: 15.00.00.00
*** 16:09:02 Number of AMPs available: 4
*** 16:09:02 Current CLI or RDBMS allows maximum row size: 64K
*** 16:09:02 Character set for this job: ASCII
 
 
003 .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
 
 
 
004 DROP TABLE FL0020e1;
 
*** 16:09:06 Command completed successfully
 
005 DROP TABLE FL0020e2;
 
*** 16:09:06 Command completed successfully
 
 
006 DROP TABLE FL0020;
 
*** 16:09:07 Command completed successfully
 
007 RECORD 201 THRU 210;
 
*** 16:09:07 Starting record number set to  : 201
*** 16:09:07 Ending record number set to    : 210
 
008 create table FL0020
    (a int,
    b char(10));
 
*** 16:09:07 Command completed successfully
 
 
009 DEFINE
    FIELD1 (integer),
    FIELD2 (char(10)),
    FILE=FDAT02;
 
*** 16:09:07 FDL4803 DEFINE statement processed
 
 
010 BEGIN LOADING FL0020
    ERRORFILES FL0020e1,FL0020e2 checkpoint 100;
 
*** 16:09:09 Session count 4 returned by the DBS overrides
             user-requested session count
*** 16:09:13 Number of FastLoad sessions requested = 4
*** 16:09:13 Number of FastLoad sessions connected = 4
*** 16:09:13 FDL4808 LOGON successful
*** 16:09:15 Number of AMPs available: 4
*** 16:09:15 BEGIN LOADING COMPLETE
 
 
011 SHOW;
 
    FILE = FDAT02
    FIELD1                           OFFSET =      0 LEN =     4 INTEGER
    FIELD2                           OFFSET =      4 LEN =    10 CHAR
    TOTAL RECORD LENGTH = 14
 
 
    ===================================================================
    =                                                                 =
    =          Insert Phase                                           =
    =                                                                 =
    ===================================================================
 
012 INSERT INTO FL0020(A,B)
    VALUES (:field1,:FIELD2);
 
*** 16:09:16 Number of recs/msg: 3382
*** 16:09:16 Starting to send to RDBMS with record 201
*** 16:09:16 Sending row 210
*** 16:09:17 Finished sending rows to the RDBMS
 
*** 16:09:17 Acquisition Phase statistics:
             Elapsed time: 00:00:01 (in hh:mm:ss)
             CPU time:     0 Seconds
             MB/sec:       0.00
             MB/cpusec:    N/A
 
013 show;
 
    FILE = FDAT02
    FIELD1                           OFFSET =      0 LEN =     4 INTEGER
    FIELD2                           OFFSET =      4 LEN =    10 CHAR
    TOTAL RECORD LENGTH = 14
 
014 LOGOFF;
 
    ===================================================================
    =                                                                 =
    =          Logoff/Disconnect                                      =
    =                                                                 =
    ===================================================================
 
*** 16:09:18 Logging off all sessions
*** 16:09:21 Total processor time used = '0.374402 Seconds'
    .        Start : Fri Jan 10 16:08:59 2014
    .        End   : Fri Jan 10 16:09:21 2014
    .        Highest return code encountered = '4'.
*** 16:09:21 FastLoad Paused