Linked services issue which connecting to OnPrim DB2

Mallik 0 Reputation points
2024-04-25T18:49:31.19+00:00

I am trying to connect to Linked services for OnPrim DB2 using a VM as middle layer, I have checked the telnet connectivity everything is connected but when I used the selfhosted and tried to connect then I get the attached error, Can any one help to resolve this issue? User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,602 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 15,676 Reputation points
    2024-04-25T19:44:25.93+00:00

    First, try to check the prerequisites :

    https://learn.microsoft.com/en-us/azure/data-factory/connector-db2?tabs=data-factory#prerequisites

    And the supported versions:

    Specifically, this DB2 connector supports the following IBM DB2 platforms and versions with Distributed Relational Database Architecture (DRDA) SQL Access Manager (SQLAM) version 9, 10 and 11. It utilizes the DDM/DRDA protocol.

    • IBM DB2 for z/OS 12.1
    • IBM DB2 for z/OS 11.1
    • IBM DB2 for z/OS 10.1
    • IBM DB2 for i 7.3
    • IBM DB2 for i 7.2
    • IBM DB2 for i 7.1
    • IBM DB2 for LUW 11
    • IBM DB2 for LUW 10.5
    • IBM DB2 for LUW 10.1

    You need to configure the Informix Server to be “DRDA enabled”, and to listen for in-bound client TCP/IP network connections on a “DRDA port” (default port number is 9089). Here is a similar thread for your reference.

    More links : https://learn.microsoft.com/en-us/answers/questions/1281170/adf-connecting-to-ibm-db2-cloud

    https://community.fabric.microsoft.com/t5/Desktop/Connecting-to-Informix/td-p/122729

     

    0 comments