Archives of the TeradataForum

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

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

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>>