I am working on a DB2 project and running into this problem. When I run quite a complicated query with joins, I have this exception "Not in a transaction ERROR  [IBM][DB2/NT] SQL0998N Error occurred during transaction or heuristic processing. Reason Code = "15". Subcode = "". SQLSTATE=58005"
I tried to increase the MSDTC timeout time to maximum (3600) as recommended by IBM, but it didnt help. Did any one have idea or solution for this, please give me a hand. Really appreciated.