=================================================================== = = = FASTLOAD UTILITY VERSION 16.10.00.00 = = PLATFORM WIN32 = = PID 11716 = = = =================================================================== =================================================================== = = = Copyright 1984-2017, Teradata Corporation. = = ALL RIGHTS RESERVED. = = = =================================================================== **** 11:44:53 Processing starting at: Tue May 02 11:44:53 2017 0001 .SESSIONS 2; **** 11:44:53 FDL4866 SESSIONS command accepted =================================================================== = = = Logon/Connection = = = =================================================================== 0002 .logon NODEID/fluser, **** 11:44:58 Teradata Database Release: 16.10.00.00 **** 11:44:58 Teradata Database Version: 16.10.00.00 **** 11:44:58 Number of AMPs available: 4 **** 11:44:58 Current CLI or RDBMS allows maximum row size: 64K **** 11:44:58 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 DROP TABLE FL0020e1; **** 11:45:00 RDBMS error 3807: Object 'FL0020e1' does not exist. 0005 DROP TABLE FL0020e2; **** 11:45:00 RDBMS error 3807: Object 'FL0020e2' does not exist. 0006 DROP TABLE FL0020; **** 11:45:00 Command completed successfully 0007 create table FL0020 (a int, b char(10)); **** 11:45:01 Command completed successfully 0008 DEFINE FIELD1 (integer), FIELD2 (char(10)), FILE=FDAT02; **** 11:45:01 FDL4803 DEFINE statement processed 0009 BEGIN LOADING FL0020 ERRORFILES FL0020e1,FL0020e2 checkpoint 100; **** 11:45:01 Session count 4 returned by the DBS overrides user-requested session count **** 11:45:05 Number of FastLoad sessions requested = 4 **** 11:45:05 Number of FastLoad sessions connected = 4 **** 11:45:05 FDL4808 LOGON successful **** 11:45:06 Number of AMPs available: 4 **** 11:45:06 BEGIN LOADING COMPLETE 0010 SHOW; FILE = FDAT02 FIELD1 OFFSET = 0 LEN = 4 INTEGER FIELD2 OFFSET = 4 LEN = 10 CHAR TOTAL RECORD LENGTH = 14 =================================================================== = = = Insert Phase = = = =================================================================== 0011 INSERT INTO FL0020(A,B) VALUES (:field1,:FIELD2); **** 11:45:07 Number of recs/msg: 3382 **** 11:45:07 Starting to send to RDBMS with record 1 **** 11:45:07 Sending row 10 **** 11:45:08 Finished sending rows to the RDBMS **** 11:45: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 0012 LOGOFF; =================================================================== = = = Logoff/Disconnect = = = =================================================================== **** 11:45:09 Logging off all sessions **** 11:45:10 Total processor time used = '0.452403 Seconds' . Start : Tue May 02 11:44:53 2017 . End : Tue May 02 11:45:10 2017 . Highest return code encountered = '4'. **** 11:45:10 FastLoad Paused