Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 09 Dec 2015 @ 17:14:36 GMT

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

Subj:   Re: Serialize and Pack factor for TPUMP jobs -
From:   Walter, Todd

Serialize means that all of the rows destined for an AMP will go through the same session. However, many AMPs' data may go through the same session and can appear in a single PACK. So one PACK can easily request as many row locks as there are rows in the PACK and those row locks can be on as many AMPs as there are rows. The row locks are requested as the rows are processed so it is definitely possible for an all-AMP operation to request an all-AMP lock after some row locks have been granted for the PACK but before all of the locks for that PACK are requested/granted.

  <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: 24 Jul 2020