|
|
Archives of the TeradataForum
Message Posted: Fri, 21 Jan 2005 @ 15:48:05 GMT
Subj: | | Re: DOS FastLoad and CLI315's |
|
From: | | John H Schuster |
Here is a copy of the output from one of the Failing FL's. The YENR table has 13m rows and takes about 4 attempts to load.
Notice the CLI513 error has a status of "Completed" which is not correct. An old manual I came across referenced "Missed or incorrect
packet..." now I can't locate the manual. We also get CLI306 errors rarely and those don't appear in the documentation either.
-------------------------------------------------------------------
- -
- FASTLOAD UTILITY VERSION 07.04.00 -
- -
-------------------------------------------------------------------
**** 07:53:11 Processing starting at: Fri Jan 21 07:53:11 2005
/*****************************************************************/
/* Data Warehouse Toolkit - FastLoad Processing */
/* Stream: STI-YENR Loading */
/* Step: Fastload YENR Staged */
/* Process date: 1/21/2005 7:53:11 AM */
/*****************************************************************/
-------------------------------------------------------------------
- -
- Logon/Connection -
- -
-------------------------------------------------------------------
0001 LOGON dbc/nsti,
**** 07:53:14 Current CLI or RDBMS allows maximum row size: 64K
**** 07:53:14 Character set for this job: ASCII
**** 07:53:21 Number of FastLoad sessions connected - 32
**** 07:53:21 FDL4808 LOGON successful
0002 DATABASE STIStaged ;
**** 07:53:21 Command completed successfully
0003 Drop Table yEnr_errors1 ;
**** 07:53:22 Command completed successfully
0004 Drop Table yEnr_errors2 ;
**** 07:53:23 Command completed successfully
0005 BEGIN LOADING yEnr
ERRORFILES yEnr_errors1, yEnr_errors2
INDICATORS ;
**** 07:53:23 Indicator mode is set to ON
**** 07:53:26 Number of AMPs available: 32
**** 07:53:26 BEGIN LOADING COMPLETE
0006 AXSMOD Oledb_Axsmod "noprompt";
**** 07:53:26 FastLoad has successfully loaded file: Oledb_Axsmod
0007 DEFINE DateSql (CHAR(23)),
DateSql_DATE (DATE),
DateSql_TIME (FLOAT),
Snum (DECIMAL(12,0)),
Enrolled (SMALLINT),
EnrCode (CHAR(5)),
Grade (SMALLINT),
Home (CHAR(8)),
Sp_Ed (CHAR(5)),
Tcode (CHAR(5)),
AtxType (CHAR(1)),
AtxCode (CHAR(3)),
LunchCode (CHAR(5)),
Sn (CHAR(7)),
Sql_Cng (CHAR(23)),
Sql_Cng_DATE (DATE),
Sql_Cng_TIME (FLOAT),
yAcadYear (INTEGER),
yDistNo (CHAR(15))FILE-C:\DWT\FastLoad\STI.yenr.amj ;
**** 07:53:27 FDL4803 DEFINE statement processed
-------------------------------------------------------------------
- -
- Insert Phase -
- -
-------------------------------------------------------------------
0008 INSERT INTO yEnr ( DateSql, DateSql_DATE, DateSql_TIME, Snum,
Enrolled,
EnrCode, Grade, Home, Sp_Ed, Tcode, AtxType,
AtxCode,
LunchCode, Sn, Sql_Cng, Sql_Cng_DATE,
Sql_Cng_TIME,
yAcadYear, yDistNo )
VALUES ( :DateSql, :DateSql_DATE, :DateSql_TIME, :Snum,
:Enrolled,
:EnrCode, :Grade, :Home, :Sp_Ed, :Tcode, :AtxType,
:AtxCode,
:LunchCode, :Sn, :Sql_Cng, :Sql_Cng_DATE,
:Sql_Cng_TIME,
:yAcadYear, :yDistNo ) ;
**** 07:53:27 Number of recs/msg: 437
**** 07:53:27 Starting to send to RDBMS with record 1
**** 07:53:36 Starting row 100000
**** 07:53:44 Starting row 200000
**** 07:53:51 Starting row 300000
**** 07:54:00 Starting row 400000
**** 07:54:08 Starting row 500000
**** 07:54:15 Starting row 600000
**** 07:54:23 Starting row 700000
**** 07:54:30 Starting row 800000
**** 07:54:38 Starting row 900000
**** 07:54:46 Starting row 1000000
**** 07:54:54 Starting row 1100000
**** 07:55:01 Starting row 1200000
**** 07:55:09 Starting row 1300000
**** 07:55:17 Starting row 1400000
**** 07:55:25 Starting row 1500000
**** 07:55:32 Starting row 1600000
**** 07:55:40 Starting row 1700000
**** 07:55:48 Starting row 1800000
**** 07:55:56 Starting row 1900000
**** 07:56:03 Starting row 2000000
**** 07:56:11 Starting row 2100000
**** 07:56:18 Starting row 2200000
**** 07:56:25 Starting row 2300000
**** 07:56:33 Starting row 2400000
**** 07:56:40 Starting row 2500000
**** 07:56:49 Starting row 2600000
**** 07:56:56 Starting row 2700000
**** 07:57:04 Starting row 2800000
**** 07:57:13 Starting row 2900000
**** 07:57:22 Starting row 3000000
**** 07:57:29 Starting row 3100000
****07:57:36 Starting row 3200000
**** 07:57:43 Starting row 3300000
**** 07:57:52 Starting row 3400000
**** 07:57:59 Starting row 3500000
**** 07:58:06 Starting row 3600000
**** 07:58:14 Starting row 3700000
**** 07:58:22 Starting row 3800000
**** 07:58:30 Starting row 3900000
**** 07:58:38 Starting row 4000000
**** 07:58:45 Starting row 4100000
**** 07:58:53 Starting row 4200000
**** 07:59:00 Starting row 4300000
**** 07:59:07 Starting row 4400000
**** 07:59:14 Starting row 4500000
**** 07:59:21 Starting row 4600000
**** 07:59:29 Starting row 4700000
**** 07:59:36 Starting row 4800000
**** 07:59:43 Starting row 4900000
**** 07:59:50 Starting row 5000000
**** 07:59:58 Starting row 5100000
**** 08:00:05 Starting row 5200000
**** 08:00:12 Starting row 5300000
**** 08:00:19 Starting row 5400000
**** 08:00:26 Starting row 5500000
**** 08:00:34 Starting row 5600000
**** 08:00:41 Starting row 5700000
**** 08:00:48 Starting row 5800000
**** 08:00:55 Starting row 5900000
**** 08:01:02 Starting row 6000000
**** 08:01:10 Starting row 6100000
**** 08:01:17 Starting row 6200000
**** 08:01:24 Starting row 6300000
**** 08:01:31 Starting row 6400000
**** 08:01:38 Starting row 6500000
**** 08:01:45 Starting row 6600000
**** 08:01:53 Starting row 6700000
**** 08:02:00 Starting row 6800000
**** 08:04:17 CLI Error 315: Completed successfully.
-------------------------------------------------------------------
- -
- Logoff/Disconnect -
- -
-------------------------------------------------------------------
**** 08:04:17 Logging off all sessions
**** 08:04:23 Total processor time used - '120.813 Seconds'
. Start : Fri Jan 21 07:53:11 2005
. End : Fri Jan 21 08:04:23 2005
. Highest return code encountered - '12'.
John HR Schuster
Senior Consultant
| |