Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 11 Dec 2002 @ 09:31:18 GMT


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


Subj:   Compatibility issues between TUF 6.0.1 and TUF 6.1.1
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, December 11, 2002 00:19 -->

Recently in our shop we have installed TUF 6.1.1 on OS/390. The older version TUF 6.0.1 is also present. The existing Teradata scripts are behaving crazy. The following are the problems being faced. If any of you have had similar experiences please advise.

1. TPUMP: We understand that the Number of columns of the table being loaded is inversly proportional to the packing factor. While we ran our existing scripts we got the message 5:17:55 UTY8001 RDBMS failure in Packing Test: 5793, Limit on the number of host ariables in USING modifier exceeded The packing factor used was 31 and the number of columns in the Teradata table is 23. Is there any relationship between packing factor & number of columns in the target table?

2. The other issue is with the TPUMP status table/view. When we run the following query, we get duplicate row error. The TPUMPSTATUSLOG_CURX does not have any rows and the table TABLE_LOAD_LOG has only one row

     UPDATE DEVCONTROLDB.TABLE_LOAD_LOG
     FROM (SELECT   INITSTARTDATE
      , INITSTARTTIME
      , LASTUPDATEDATE
      , LASTUPDATETIME
      , RECORDSREAD
      , RECORDSSKIPPED
      , RECORDSREJCTED
      , RECORDSOUT
      , RECORDSERRORED
     FROM DEVCONTROLDB.TPUMPSTATUSLOG_CURX   T
     WHERE IND = 'R'
       AND LOGTABLE  = 'STORE_POLL_TPLOG')
       TT (TLSD, TLST, TLED, TLET, RRC, RSC, RJC, ROC, REC)
     SET TABLE_LOAD_START_DT = TT.TLSD
       , TABLE_LOAD_START_TIME = TT.TLST
       , TABLE_LOAD_TERM_DT = TT.TLED
       , TABLE_LOAD_END_TIME = TT.TLET
       , RECORDS_READ_CNT = TT.RRC
       , RECORDS_SKIPPED_CNT = TT.RSC
       , RECORDS_REJECTED_CNT = TT.RJC
       , RECORDS_OUTPUT_CNT = TT.ROC
       , RECORDS_ERROR_CNT = TT.REC
       , LOAD_STATUS_IND = 'C'
     WHERE TABLENAME   = 'STORE_ORDER_POLLING'
        AND LOAD_STATUS_IND = 'S';
      *** Failure 2802 Duplicate row error in DevControlDB.TABLE_LOAD_LOG.
                     Statement# 1, Info =0


     
  <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