deadlock issue in simultaneous DML statements.

Database
Enthusiast

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,

Tags (1)
1 REPLY
Enthusiast

Re: deadlock issue in simultaneous DML statements.

Use locking modifiers before DML statements to avoid deadlock issue.