Archives of the TeradataForum

Message Posted: Tue, 14 Jul 2015 @ 09:23:20 GMT

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

<-- Anonymously Posted: Tuesday, July 14, 2015 12:24 -->

Hi,

For a PPI table (with a NUPI), is it possible to load data concurrently to the same table via multiple sessions by the same user ? In other words, in a PPI table does TD lock only a particular partition for loading or the entire table is locked ?

For e.g. we have the following table :

     Create table test_concur
     (
     Stud_Id varchar(10),
     Stud_Name varchar(100),
     Course_Id varchar(10)
     )Primary Index (Stud_Id)
     PARTITION BY (Course_Id);
     Now consider the following records being loaded by each session - Session 1:
     1001, John Davis, 9001
     1004, Mike Connor, 9001
     Session 2:
     1002, Peter Martin, 9002
     1005, Kevin Pike, 9002

Assume that all the above records hash to the same AMP. Will TD allow loading these 4 records concurrently (since partition is different) or will it block one session until the earlier session concludes loading to the table ?

Please share your thoughts...

Thanks

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