Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 30 Jul 2002 @ 09:25:08 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: TPUMP-Multiple table insert/update
From:   Heard, Duncan

Further to the last point I would ALWAYS prebuild macros where you have the following:

* More than one TPUMP job tends to start in the space of 30 secs.

* Many DML statements in a single TPUMP job

* Lots of DDL going on when the TPUMP jobs tend to be started

Note: If you have many different DML statements you can sometimes get considerable performance gains from splitting them up into multiple parallel TPUMP jobs running across the same file - BUT PREBUILD THOSE MACROS (or pay the price)! This technique can also be used to split out upserts to allow a higher packrate (i.e. > 1) for all the other non-upsert DML within the job.



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