All Forums Database
bhartiya007 29 posts Joined 03/14
20 Apr 2015
deadlock issue in simultaneous DML statements.

Hi All,
We have some files which are being loaded to teradata tables. The files are loaded via different pipelines in informatica and parallel insert, update and delete operations are taking place on the target table.
How can we avoid that at the database level?
Do we have any workaround for that?
 
Regards,

@Amit
sharib hussain 12 posts Joined 01/13
22 Apr 2015

Use locking modifiers before DML statements to avoid deadlock issue. 

Thanks & Regards,
Sharib Hussain

You must sign in to leave a comment.