Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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 ;
     .BEGIN LOAD SESSIONS 10
      ERRORTABLE xxxx.PumpErr NOMONITOR;

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