Archives of the TeradataForum
Message Posted: Wed, 11 Dec 2002 @ 09:31:18 GMT
<-- 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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|