===================================================================
= =
= FASTLOAD UTILITY VERSION 15.10.00.00 =
= PLATFORM WIN32 =
= PID 6956 =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2015, 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.10.00.00
*** 16:09:02 Teradata Database Version: 15.10.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.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
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