Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 18 Mar 2010 @ 19:14:34 GMT

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

Subj:   Re: TPUMP Installation
From:   Bob Hahn

BTEQ sends Teradata requests containing 1 or more records controlled by pack.

Increased pack = more concurrency inside Teradata--for parameter arrays, the PE dispatcher sends all records in a request (steps) in parallel up to the amp count. If multiple records hash to the same amp they are sent in the same step. So with pack 1 there would be 1 dml running per session concurrently, with higher pack this increases. That helps throughput.

If sessions are greater than 1, then concurrency is increased further by sending requests concurrently on different sessions.

Increasing sessions and pack increases throughput.

One thing to watch with parameter arrays though--you can use up 1 to AWT / AMP / session concurrently.

  <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