===================================================================
= =
= FASTLOAD UTILITY VERSION 16.20.00.00 =
= PLATFORM LINUX =
= PID 17433 =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2017, Teradata Corporation. =
= ALL RIGHTS RESERVED. =
= =
===================================================================
**** 02:50:02 Processing starting at: Wed Sep 20 02:50:02 2017
===================================================================
= =
= Logon/Connection =
= =
===================================================================
0001 .LOGON NODEID/fluser,
**** 02:50:02 Teradata Database Release: 16.20.00.00
**** 02:50:02 Teradata Database Version: 16.20.00.00
**** 02:50:02 Number of AMPs available: 4
**** 02:50:02 Current CLI or RDBMS allows maximum row size: 64K
**** 02:50:02 Character set for this job: ASCII
0002 DROP TABLE FL0161e1;
**** 02:50:02 RDBMS error 3807: Object 'FL0161e1' does not exist.
0003 DROP TABLE FL0161e2;
**** 02:50:02 RDBMS error 3807: Object 'FL0161e2' does not exist.
0004 DROP TABLE FL0161;
**** 02:50:03 Command completed successfully
0005 CREATE TABLE FL0161, FALLBACK(
c1 integer,
c2 char(10),
c3 varchar(3))
UNIQUE PRIMARY INDEX (c1);
**** 02:50:03 Command completed successfully
0006 BEGIN LOADING FL0161 ERRORFILES FL0161e1,FL0161e2;
**** 02:50:03 Session count 4 returned by the DBS overrides
user-requested session count
**** 02:50:04 Number of FastLoad sessions connected = 4
**** 02:50:04 FDL4808 LOGON successful
**** 02:50:04 Number of AMPs available: 4
**** 02:50:04 BEGIN LOADING COMPLETE
0007 DEFINE c1 (integer), c2 (char(10)), c3 (varchar(3)) FILE=INDAT24;
**** 02:50:04 FDL4803 DEFINE statement processed
0008 SHOW;
FILE = INDAT24
C1 OFFSET = 0 LEN = 4 INTEGER
C2 OFFSET = 4 LEN = 10 CHAR
C3 OFFSET = 14 LEN = 3 VARCHAR
TOTAL RECORD LENGTH = 19
===================================================================
= =
= Insert Phase =
= =
===================================================================
0009 INSERT INTO FL0161 (c1,c2,c3) VALUES (:c1,:c2,:c3);
**** 02:50:04 Number of recs/msg: 2920
**** 02:50:04 Starting to send to RDBMS with record 1
**** 02:50:04 Sending row 9
**** 02:50:04 Finished sending rows to the RDBMS
**** 02:50:04 Acquisition Phase statistics:
Elapsed time: 00:00:00 (in hh:mm:ss)
CPU time: 0 Seconds
MB/sec: N/A
MB/cpusec: N/A
0010 LOGOFF;
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 02:50:04 Logging off all sessions
**** 02:50:04 Total processor time used = '0.94 Seconds'
. Start : Wed Sep 20 02:50:02 2017
. End : Wed Sep 20 02:50:04 2017
. Highest return code encountered = '4'.
**** 02:50:04 FastLoad Paused