Share via

Unable to create the complete db2trc dump file in Azure function app environment

Tapan Kumar Ghosh 1 Reputation point
2021-12-29T17:40:53.89+00:00

Steps performed :

  • We created a Httptrigger based Azure Function using Db2 .NET Core driver (IBM.Data.DB2.Core v3.1.0.500) from nuget repository https://www.nuget.org/packages/IBM.Data.DB2.Core as mentioned in blog : https://community.ibm.com/community/user/hybriddatamanagement/blogs/vishwa-hs1/2021/08/06/azure-functions-using-db2-net-core-drivers.
  • And we are able to connect to IBM dashDB cloud database using our Db2 .NET Core driver both locally with Visual studio Httptrigger based Azure Function app and after publishing it in azure cloud.
  • Also, we are able to connect to Db2 for z/OS and Db2 for i databases (available on-prem) with Visual studio Httptrigger based Azure Function using Db2 .NET Core driver. However, after publishing the same azure function in azure cloud, we are unable to connect to the same server. When we invoke the Azure Function through the web browser by selecting the link provided in the Azure Function and then appending the function name for e.g. <FunctionURL>\api\HttpExample, we got below error:

Exception Message:
ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "137.134.252.115". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "", "". SQLSTATE=08001

  • To know the cause of this TCP/IP socket error, we tried to create a db2trc dump for this azure function app execution. The db2trc dump actually captures all our driver api call during the execution of this azure function app execution. We keep the db2trc dump in D:\home\LogFiles where we have read and write permission.
  • We could see that db2trc dump file got generated, however it did not capture all driver api calls in it.
  • This problem is only specific to azure function app, whereas we are able to capture the db2trc dump in azure web application deployment scenario in azure cloud environment.
  • Can somebody assist us on why we are facing this problem in capturing db2trc dump in only azure function app cloud environment.

Thanks,
Tapan

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,909 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.