Archives of the TeradataForum
Message Posted: Thu, 18 Mar 2010 @ 19:14:34 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|