Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Jan 2005 @ 15:48:05 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016