===================================================================
= =
= FASTLOAD UTILITY VERSION 16.10.00.00 =
= PLATFORM WIN32 =
= PID 10276 =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2017, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================
**** 11:47:19 Processing starting at: Tue May 02 11:47:18 2017
0001 .SESSIONS 2;
**** 11:47:19 FDL4866 SESSIONS command accepted
===================================================================
= =
= Logon/Connection =
= =
===================================================================
0002 .logon NODEID/fluser,
**** 11:47:23 Teradata Database Release: 16.10.00.00
**** 11:47:23 Teradata Database Version: 16.10.00.00
**** 11:47:23 Number of AMPs available: 4
**** 11:47:23 Current CLI or RDBMS allows maximum row size: 64K
**** 11:47:23 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=FDAT02B;
**** 11:47:25 FDL4803 DEFINE statement processed
0005 BEGIN LOADING FL0020
ERRORFILES FL0020e1,FL0020e2 checkpoint 100;
**** 11:47:26 Session count 4 returned by the DBS overrides
user-requested session count
**** 11:47:30 Number of FastLoad sessions requested = 4
**** 11:47:30 Number of FastLoad sessions connected = 4
**** 11:47:30 FDL4808 LOGON successful
**** 11:47:31 FastLoad is continuing a multifile job
**** 11:47:31 Number of AMPs available: 4
**** 11:47:31 BEGIN LOADING COMPLETE
0006 SHOW;
FILE = FDAT02B
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:47:32 Number of recs/msg: 3382
**** 11:47:32 Starting to send to RDBMS with record 1
**** 11:47:32 Sending row 10
**** 11:47:32 Finished sending rows to the RDBMS
**** 11:47:32 Acquisition Phase statistics:
Elapsed time: 00:00:00 (in hh:mm:ss)
CPU time: 0 Seconds
MB/sec: N/A
MB/cpusec: N/A
===================================================================
= =
= End Loading Phase =
= =
===================================================================
0008 .end loading;
**** 11:47:34 END LOADING COMPLETE
Total Records Read = 30
Total Error Table 1 = 0 ---- Table has been dropped
Total Error Table 2 = 0 ---- Table has been dropped
Total Inserts Applied = 30
Total Duplicate Rows = 0
Start: Tue May 02 11:47:33 2017
End : Tue May 02 11:47:34 2017
**** 11:47:34 Application Phase statistics:
Elapsed time: 00:00:01 (in hh:mm:ss)
0009 LOGOFF;
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 11:47:35 Logging off all sessions
**** 11:47:37 Total processor time used = '0.421203 Seconds'
. Start : Tue May 02 11:47:18 2017
. End : Tue May 02 11:47:37 2017
. Highest return code encountered = '0'.
**** 11:47:37 FDL4818 FastLoad Terminated