===================================================================
= =
= 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