Archives of the TeradataForum
Message Posted: Thu, 18 Mar 2010 @ 19:14:34 GMT
| 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.
| 
