We have the following setup:
--> DB2 Client on Win
---> Call of SP X on LUW on Unix
---> read iSeries DB2
---> update z/OS DB2
----> call autonomous SP Y on same LUW
---->update log table on z/OS DB2
Stored procedure ends normally but on return to Powershell the process hangs. We can see that SP ended OK.
I removed the "autonomous" from the logging SP "Y" and now it works fine.
We could not reproduce this problem in test, it only happened in production. Does anybody have any idea what could cause the difference between test and prod behaviour? Additionally, the process hanged ONLY if the SP "X" ran for over about 1 minute.