Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Jan 2008 @ 16:41:47 GMT


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


Subj:   MultiLoad - an unexplainable 'configuration
 
From:   Hillel Eilat

A simple MULTILOAD script is applied as follows:

     *D:\DEV\....\tdata>mload -e loadMloadFactTable.err <
     loadMloadFactTable.ctl > loadMloadFactTable.log*

     * *

It constantly generates a kind of 'unsupported configuration' (??) as listed below.

     ***** 18:15:40 UTY0805 RDBMS failure, 2550: MLoad error: bad internal
           status - unsupported*
           configuration (one AMP).*

Similar scripts submitted to TPUMP and FastLoad work fine.

Any help will be appreciated.


Thanks

Hillel.

     **** 18:15:39 UTY2413 Error Logging is enabled: loadMloadFactTable.err

     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Utility    Release MLOD.07.09.00.000              =
     =          Platform WIN32                                              =
     =                                                                      =
     ------------------------------------------------------------------------
     =                                                                      =
     =          Copyright 1990-2005, NCR Corporation. ALL RIGHTS RESERVED.  =
     =                                                                      =
     ------------------------------------------------------------------------

     ------------------------------------------------------------------------
     **** 18:15:39 UTY2411 Processing start date: MON JAN 28, 2008
     ------------------------------------------------------------------------

     ------------------------------------------------------------------------
     =                                                                      =
     =          Logon/Connection                                            =
     =                                                                      =
     ------------------------------------------------------------------------

     0001 /**************************************************************/
          /*                                                            */
          /* Load data into fact Table equivalent structure             */
          /*                                                            */
          /**************************************************************/

           /***********************************************/
           /* STEP01 CREATES THE TABLES FOR THE MLOAD JOB */
           /*                                             */
           /***********************************************/

           /* .RUN FILE logon; */

           .LOGON xxx.yy.zz.www/dbc,;

     **** 18:15:39 UTY6214 Reminder: A .Logtable statement must
                   be entered for a successful logon.


     ------------------------------------------------------------------------
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ------------------------------------------------------------------------

     0002 .LOGTABLE MSTEST.MYTABLE;
     **** 18:15:39 UTY8400 Teradata Database Release: V2R.06.02.00.00
     **** 18:15:39 UTY8400 Teradata Database Version: 06.02.00.00
     **** 18:15:39 UTY8400 Default character set: ASCII
     **** 18:15:39 UTY8400 Current RDBMS has interval support
     **** 18:15:39 UTY8400 Current RDBMS has UDT support
     **** 18:15:39 UTY8400 Maximum supported buffer size: 1M
     **** 18:15:39 UTY8400 Data Encryption supported by RDBMS server
     **** 18:15:39 UTY6211 A successful connect was made to the RDBMS.
     **** 18:15:39 UTY6210 Logtable 'MSTEST.MYTABLE' indicates that a
                           restart is in progress.
     0003 DATABASE MSTEST;
     **** 18:15:39 UTY1016 'DATABASE' request successful.
     0004 DROP TABLE tlnt2err;
     **** 18:15:39 UTY1008 RDBMS failure: 3807, Object 'tlnt2err' does not exist.
     0005 DROP TABLE factTableM;
     **** 18:15:39 UTY1016 'DROP' request successful.
     0006 CREATE TABLE FactTableM, fallback
                (
                 int0 VARCHAR(6) CHARACTER SET LATIN NOT CASESPECIFIC,
                    .
                    .
                    .

           PRIMARY INDEX ( int0 );

     **** 18:15:39 UTY1016 'CREATE' request successful.

     0007 /*****************************************************************/
          /* BEGIN LOAD WITH ALL THE OPTIONS SPECIFIED                     */
          /*****************************************************************/

           .begin mload tables factTableM sessions 1 checkpoint 1;

     ------------------------------------------------------------------------
     =                                                                      =
     =          Processing MultiLoad Statements                             =
     =                  `                                                   =
     ------------------------------------------------------------------------

     0008 /*****************************************************************/
          /*                                                               */
          /* VARCHAR has been specified for easing the formating by using  */
          /* the same delimited format as applied for Oracle's SQL*Loader  */
          /* and our inhouse ODBCloader                                    */
          /*                                                               */
          /*                                                               */
          /* Data volume remains quite similar...                          */
          /*                                                               */
          /*****************************************************************/

           .LAYOUT LAY1A;
     0009 .FIELD      int0      * varchar(6);
             .
             .
             .
             .
     0029 /*.DML LABEL LABELA; */
           .DML LABEL LABELA;
     0030 INSERT INTO factTableM.*;
     0031 .IMPORT INFILE ./factTableL100000.dat FORMAT VARTEXT '|'
           layout LAY1A
           apply LABELA;
     0032 .END MLOAD;


     ------------------------------------------------------------------------
     =                                                                      =
     =          MultiLoad Initial Phase                                     =
     =                                                                      =
     ------------------------------------------------------------------------

     **** 18:15:39 UTY0829 Options in effect for this MultiLoad import task:
           .       Sessions:    1 session(s).
           .       Checkpoint:  1 minute(s).
           .       Tenacity:    4 hour limit to successfully connect load sessions.
           .       Errlimit:    No limit in effect.
           .       AmpCheck:    In effect for apply phase transitions.
     **** 18:15:39 UTY0817 MultiLoad submitting the following request:
           Select NULL from MSTEST.MYTABLE where (LogType = 125) and (Seq = 1) and
           (MloadSeq = 0);
     **** 18:15:39 UTY0817 MultiLoad submitting the following request:
           Select NULL from MSTEST.MYTABLE where (LogType = 120) and (Seq = 1);
     **** 18:15:40 UTY0812 MLOAD session(s) requested: 1.
     **** 18:15:40 UTY0815 MLOAD session(s) connected: 1.
     **** 18:15:40 UTY0817 MultiLoad submitting the following request:
           BEGIN MLOAD factTableM WITH INTERVAL;
     ***** 18:15:40 UTY0805 RDBMS failure, 2550: MLoad error: bad internal
                            status - unsupported *configuration (one AMP).*

     ------------------------------------------------------------------------
     =                                                                      =
     =          Logoff/Disconnect                                           =
     =                                                                      =
     ------------------------------------------------------------------------

     **** 18:15:40 UTY6215 The restart log table has NOT been dropped.
     **** 18:15:41 UTY6212 A successful disconnect was made from the RDBMS.
     **** 18:15:41 UTY2410 Total processor time used = '0.125 Seconds'
           .       Start : 18:15:39 - MON JAN 28, 2008
           .       End   : 18:15:41 - MON JAN 28, 2008
           .       Highest return code encountered = '12'.


     
  <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