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