===================================================================
= =
= FASTLOAD UTILITY VERSION 17.20.00.04 =
= PLATFORM LINUX 64-bit =
= PID 1264620 =
= =
= FASTLOAD UTILITY is DEPRECATED. =
= It is provided to run existing workloads created =
= prior to 07-SEP-2023. =
= Please use Teradata Parallel Transporter for =
= workloads. =
= =
===================================================================
===================================================================
= =
= Copyright 1984-2023 Teradata. =
= All rights reserved. =
= =
===================================================================
**** 02:42:34 Processing starting at: Sun Sep 10 02:42:34 2023
===================================================================
= =
= Logon/Connection =
= =
===================================================================
0001 .LOGON NODEID/fluser,
**** 02:42:34 Teradata Database Release: 17.20.00.00
**** 02:42:34 Teradata Database Version: 17.20.00.00
**** 02:42:34 Number of AMPs available: 2
**** 02:42:34 Current CLI or RDBMS allows maximum row size: 64K
**** 02:42:34 Character set for this job: ASCII
0002 DROP TABLE FL0161e1;
**** 02:42:34 RDBMS error 3807: Object 'FL0161e1' does not exist.
0003 DROP TABLE FL0161e2;
**** 02:42:34 RDBMS error 3807: Object 'FL0161e2' does not exist.
0004 DROP TABLE FL0161;
**** 02:42:34 RDBMS error 3807: Object 'FL0161' does not exist.
0005 CREATE TABLE FL0161, FALLBACK(
c1 integer,
c2 char(10),
c3 varchar(3))
UNIQUE PRIMARY INDEX (c1);
**** 02:42:34 Command completed successfully
0006 BEGIN LOADING FL0161 ERRORFILES FL0161e1,FL0161e2;
**** 02:42:34 Session count 2 returned by the DBS overrides
user-requested session count
**** 02:42:34 Number of FastLoad sessions connected = 2
**** 02:42:34 FDL4808 LOGON successful
**** 02:42:35 Number of AMPs available: 2
**** 02:42:35 BEGIN LOADING COMPLETE
0007 DEFINE c1 (integer), c2 (char(10)), c3 (varchar(3)) FILE=INDAT24;
**** 02:42:35 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:42:35 Number of recs/msg: 2920
**** 02:42:35 Starting to send to RDBMS with record 1
**** 02:42:35 Sending row 9
**** 02:42:35 Finished sending rows to the RDBMS
**** 02:42:35 Acquisition Phase statistics:
Elapsed time: 00:00:00 (in hh:mm:ss)
CPU time: 0.000279 Seconds
MB/sec: N/A
MB/cpusec: 0.58
0010 LOGOFF;
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================
**** 02:42:35 Logging off all sessions
**** 02:42:35 Total processor time used = '0.023661 Seconds'
. Start : Mon Aug 7 02:42:34 2023
. End : Mon Aug 7 02:42:35 2023
. Highest return code encountered = '4'.
**** 02:42:35 FastLoad Paused