|
|
|
 |
 |
Archives of the TeradataForumMessage Posted: Mon, 28 Jan 2008 @ 16:41:47 GMT
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'.
| ||||||||||||||||||||||||||||||||||||||||||||||
| | ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
| Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
| Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||
