 |
 |
Archives of the TeradataForum
Message Posted: Wed, 11 Dec 2002 @ 09:31:18 GMT
| 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
| |
