Problem with autonomous stored procedure and federated server

Lauri Pietarinen

Problem with autonomous stored procedure and federated server

Hi!

We have the following setup:

MS Powershell

  --> OLEDB

      --> 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.

 

Thanks,

Lauri Pietarinen

tel. +350-50-5942011