Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2005 @ 16:39:16 GMT

  <Prev Next>  
Next> Last>>  

Subj:   TPump Update
From:   Hassinger, Bill

I am trying to use TPUMP to update a table for the first time. Below is my Windows script. The job runs, but it takes longer then I would expect. I have seen where with 10 sessions, 9 will be blocking each other. I thought TPUMP used row level locks. This table is in test and nothing else is happening on it. Am I missing something in my script?

The input file contains the PI of the target table, I am updating 22000 records in a 3 mil record table. It is taking 20 minutes.

     /*  Sample TPump UpDate Script */

     .LOGTABLE xxxx.PumpLog;
     .LOGON yyyyy,zzzzzz ;

     .LAYOUT inpump;
     .FIELD TCN 1  VarChar(17);

     .DML LABEL frstpump;

     UPDATE xxxx.claimheader Set FinalVersionInd = 'N' Where
     TransactionControlNumber = :TCN;

     /* FORMAT defines delimited (Vartext) or Fix Length (Unformat) input file */
     .IMPORT INFILE ffffff.txt  FORMAT vartext LAYOUT inpump APPLY frstpump;
     .END LOAD;

Bill H

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023