First Output File - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities
     ===================================================================
     =                                                                 =
     =          FASTLOAD UTILITY     VERSION 16.10.00.00               =
     =          PLATFORM WIN32                                         =
     =          PID      11716                                         =
     =                                                                 =
     ===================================================================

     ===================================================================
     =                                                                 =
     =          Copyright 1984-2017, Teradata Corporation.             =
     =          ALL RIGHTS RESERVED.                                   =
     =                                                                 =
     ===================================================================

**** 11:44:53 Processing starting at: Tue May 02 11:44:53 2017

0001 .SESSIONS 2;

**** 11:44:53 FDL4866 SESSIONS command accepted


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

0002 .logon NODEID/fluser,

**** 11:44:58 Teradata Database Release: 16.10.00.00
**** 11:44:58 Teradata Database Version: 16.10.00.00
**** 11:44:58 Number of AMPs available: 4
**** 11:44:58 Current CLI or RDBMS allows maximum row size: 64K
**** 11:44:58 Character set for this job: ASCII


0003 .SHOW VERSION;

     FastLoad Version 16.10.00.00 for Win 32 running Windows Sockets
     FastLoad  : 16.00.00.03
     FastCmds  : 16.00.00.05
     FastIO    : 16.00.00.01
     FastMBCS  : 16.00.00.00
     FastNtfy  : 15.00.00.00
     FastPars  : 16.00.00.01
     FastSQL   : 16.00.00.15
     FastUtil  : 15.10.00.00
     Fdlosdep  : 13.01.00.00
     Teradata Data Connector  : 16.10.00.00
     PMPROCS   : 16.00.00.08
     PMRWFMT   : 16.00.00.03
     PMTRCE    : 15.10.00.01
     PMMM      : 13.00.00.01
     PMUDDI    : 16.00.00.01
     DCUDDI    : 16.00.00.04
     PMHEXDMP  : 14.10.00.00
     PMUNXDSK  : 16.00.00.05
     ICUVER    : TDICU, 16.10.00.00
     CLIV2     : 16.00.00.37
     MTDP      : 16.00.00.17
     MOSIos    : 16.00.00.10
     MOSIDEP   : 16.10.00.01
     OSENCRYPT : N/A
     OSERR     : 16.00.00.05

     FastLoad linking date: Apr 17 2017



0004 DROP TABLE FL0020e1;

**** 11:45:00 RDBMS error 3807: Object 'FL0020e1' does not exist.


0005 DROP TABLE FL0020e2;

**** 11:45:00 RDBMS error 3807: Object 'FL0020e2' does not exist.


0006 DROP TABLE FL0020;

**** 11:45:00 Command completed successfully


0007 create table FL0020
     (a int,
     b char(10));

**** 11:45:01 Command completed successfully


0008 DEFINE
     FIELD1 (integer),
     FIELD2 (char(10)),
     FILE=FDAT02;

**** 11:45:01 FDL4803 DEFINE statement processed


0009 BEGIN LOADING FL0020
     ERRORFILES FL0020e1,FL0020e2 checkpoint 100;

**** 11:45:01 Session count 4 returned by the DBS overrides
              user-requested session count
**** 11:45:05 Number of FastLoad sessions requested = 4
**** 11:45:05 Number of FastLoad sessions connected = 4
**** 11:45:05 FDL4808 LOGON successful
**** 11:45:06 Number of AMPs available: 4
**** 11:45:06 BEGIN LOADING COMPLETE


0010 SHOW;

     FILE = FDAT02
     FIELD1                           OFFSET =      0 LEN =     4 INTEGER
     FIELD2                           OFFSET =      4 LEN =    10 CHAR
     TOTAL RECORD LENGTH = 14


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

0011 INSERT INTO FL0020(A,B)
     VALUES (:field1,:FIELD2);

**** 11:45:07 Number of recs/msg: 3382
**** 11:45:07 Starting to send to RDBMS with record 1
**** 11:45:07 Sending row 10
**** 11:45:08 Finished sending rows to the RDBMS

**** 11:45: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


0012 LOGOFF;

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

**** 11:45:09 Logging off all sessions
**** 11:45:10 Total processor time used = '0.452403 Seconds'
     .        Start : Tue May 02 11:44:53 2017
     .        End   : Tue May 02 11:45:10 2017
     .        Highest return code encountered = '4'.
**** 11:45:10 FastLoad Paused