Distributed transactions are not performed by PowerCenter in any way. At least not that I've ever heard of.
So I fear that something else is the culprit. Maybe a Stored Procedure invoked via a Stored Procedure transformation or some SQL statement executed in a SQL Transformation or in a SQL query override in a relational source qualifier.
Could you please check whether at any of these places in the affected mapping some SQL code is used which may call for distributed transactions?
Check target connections, please
Winsql tool is the culprit here.
Lock is being created by winql if any DDL query is being executed.So everytime powercenter executes it fails.
So the solution is to disconnect the Database(DB2) and then execute the workflow. It will work fine.
Once it executes successfully, the data can be validated after connecting to the database.
There is no issue with the target connection.
Its the winsql that causes this issue. Disconnect it if you are running any informatica workflow.