Archives of the TeradataForum

Message Posted: Wed, 09 Aug 2006 @ 21:09:23 GMT

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

Hi, i have a rare problem with a MLOAD that loads 3 files from a list of files. This is the begin of the log:

     .SET MAXERROR 8;
     +---------+---------+---------+---------+---------+---------+

     RELEASE MLOAD tmp_dune.tmp_archivos_filtrar;
      *** Total elapsed time was 1 second.

     +---------+---------+---------+---------+---------+---------+

     .IF ERRORCODE = 2572 THEN .GOTO NODROP;
     +---------+---------+---------+---------+---------+---------+
     DROP TABLE TEMPORAL.LG_tmp_archivos_filtrar;

      *** Table has been dropped.
      *** Total elapsed time was 1 second.


     +---------+---------+---------+---------+---------+---------+
     DROP TABLE TEMPORAL.WT_tmp_archivos_filtrar;
      *** Total elapsed time was 1 second.

     +---------+---------+---------+---------+---------+---------+
     DROP TABLE TEMPORAL.ET_tmp_archivos_filtrar;
      *** Total elapsed time was 1 second.

     +---------+---------+---------+---------+---------+---------+
     DROP TABLE TEMPORAL.UV_tmp_archivos_filtrar;
      *** Total elapsed time was 1 second.

     +---------+---------+---------+---------+---------+---------+

     .QUIT;
      *** You are now logged off from the DBC.
      *** Exiting BTEQ...
      *** RC (return code) = 8

And this is the end:

     **** 00:55:17 UTY0817 MultiLoad submitting the following request:
          MLOAD tmp_dune.tmp_archivos_filtrar with TEMPORAL.WT_tmp_archivos_filtrar
          errortables TEMPORAL.ET_tmp_archivos_filtrar, TEMPORAL.UV_tmp_archivos_filtrar;
     **** 00:55:17 UTY0805 RDBMS failure, 3803: Table
     'WT_tmp_archivos_filtrar' already exists.

     ------------------------------------------------------------------------
          -                                                                 -
          -          Logoff/Disconnect                                      -
          -                                                                 -
     ------------------------------------------------------------------------
     **** 00:55:17 UTY6215 The restart log table has NOT been dropped.
     **** 00:55:19 UTY6212 A successful disconnect was made from the RDBMS.
     **** 00:55:19 UTY2410 Total processor time used = '0.23 Seconds'
          .       Start : 00:55:04 - WED AUG 09, 2006
          .       End   : 00:55:19 - WED AUG 09, 2006
          .       Highest return code encountered = '12'.

I notice that the DROP at the beggining doesn't do nothing:

     DROP TABLE TEMPORAL.WT_tmp_archivos_filtrar;
      *** Total elapsed time was 1 second.

It's doesn't says "Table Have Been Dropped" or somthing like that.

Any idea??

Sorry for my English, y hope u understand me.

Bye! And thanks

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina

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