InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:43:07 GMT20http://www.teradata.com/teradataforum/Topic9278-5-1.aspxWhy dont you create corresponding views for the tables to be loaded with access locks defined in the view and then use these views for the load purposes rather than directly loading the tables. This might solve your deadlocks problem.Mon, 29 Oct 2007 09:21:28 GMTramakrishna_vedantamhttp://www.teradata.com/teradataforum/Topic9278-5-1.aspxWe are using TPump upsert, updates while running ETL against Teradata using informatica. workflows are failing because of deadlocks. As i understand because transactions are read committed by default, select statements lock the table and prevent updates.I noticed that in Informatica loader Tpump configuration, it serialize is unchecked, deadlocks issue get resolved.Can somebody explain me what role does serialize plays here and how it is able to avoild deadlocks on table for concurrent running workflow sessions.Wed, 17 Oct 2007 07:58:07 GMTniaggarw