===================================================================
= =
= FASTLOAD UTILITY VERSION 16.10.00.00 =
= PLATFORM WIN32 =
= PID 12264 =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2017, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================
**** 11:45:59 Processing starting at: Tue May 02 11:45:59 2017
0001 .SESSIONS 2;
**** 11:45:59 FDL4866 SESSIONS command accepted
===================================================================
= =
= Logon/Connection =
= =
===================================================================
0002 .logon NODEID/fluser,
**** 11:46:03 Teradata Database Release: 16.10.00.00
**** 11:46:03 Teradata Database Version: 16.10.00.00
**** 11:46:03 Number of AMPs available: 4
**** 11:46:03 Current CLI or RDBMS allows maximum row size: 64K
**** 11:46:03 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 DEFINE
FIELD1 (integer),
FIELD2 (char(10)),
FILE=FDAT02A;
**** 11:46:05 FDL4803 DEFINE statement processed
0005 BEGIN LOADING FL0020
ERRORFILES FL0020e1,FL0020e2 checkpoint 100;
**** 11:46:06 Session count 4 returned by the DBS overrides
user-requested session count
**** 11:46:10 Number of FastLoad sessions requested = 4
**** 11:46:10 Number of FastLoad sessions connected = 4
**** 11:46:10 FDL4808 LOGON successful
**** 11:46:11 FastLoad is continuing a multifile job
**** 11:46:11 Number of AMPs available: 4
**** 11:46:11 BEGIN LOADING COMPLETE
0006 SHOW;
FILE = FDAT02A
FIELD1 OFFSET = 0 LEN = 4 INTEGER
FIELD2 OFFSET = 4 LEN = 10 CHAR
TOTAL RECORD LENGTH = 14
===================================================================
= =
= Insert Phase =
= =
===================================================================
0007 INSERT INTO FL0020(A,B)
VALUES (:field1,:FIELD2);
**** 11:46:12 Number of recs/msg: 3382
**** 11:46:12 Starting to send to RDBMS with record 1
**** 11:46:12 Sending row 10
**** 11:46:12 Finished sending rows to the RDBMS
**** 11:46:12 Acquisition Phase statistics:
Elapsed time: 00:00:00 (in hh:mm:ss)
CPU time: 0 Seconds
MB/sec: N/A
MB/cpusec: N/A
0008 LOGOFF;
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 11:46:13 Logging off all sessions
**** 11:46:15 Total processor time used = '0.405603 Seconds'
. Start : Tue May 02 11:45:59 2017
. End : Tue May 02 11:46:15 2017
. Highest return code encountered = '4'.
**** 11:46:15 FastLoad Paused