Archives of the TeradataForum

Message Posted: Mon, 30 Aug 2010 @ 14:42:01 GMT

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

Hi,

This is with regard to DataStage 8.1 with Teradata 13

We do have few ETL jobs which try to insert or update the same table at the same time.

Due to which we get the error "RDBMS code 2631: Transaction ABORTed due to deadlock."

Please let me know will this work LOCKING FOR WRITE

Please let me know what can be done to avoid the deadlock issue.

Thank You,

Naveen

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