Deadlocks whenusing Teradata with Informatica

Database
KVB
Enthusiast

Deadlocks whenusing Teradata with Informatica

Hi All,

We are using PDO (where all the transformation logic executed on database side)in informatica by creating temporray views.When running multiple flows in Production,we are facing deadlocks.

Are there any basic suggestions to follow or to be customized to reduce the deadlocks?

Regards

KVB

3 REPLIES
Enthusiast

Re: Deadlocks whenusing Teradata with Informatica

It could be due to many reasons because of PDO.Are  you using bteq, tpump etc? Are they insert,update etc.

How many batch ids are accessing the same resource? What are your view creation scripts if you can share? Wwhich part of the flow...and so on and so forth.

Using MSR can help since, it takes care of dependencies.Serialize tpump. But , without much detail, it is hard to say.

Cheers,

KVB
Enthusiast

Re: Deadlocks whenusing Teradata with Informatica

Yes.I will look into the details.

Teradata Employee

Re: Deadlocks whenusing Teradata with Informatica

How is your workflow arranged? Ideally it should be managed there to ensure flows having same target table are sequenced.