ADF Connecting to IBM DB2 Cloud

Question

I am trying to connect Azure Data Factory (ADF) to an IBM DB2 Cloud instance. I have a simple scenario in mind with basic authentication but I am receiving the error:

Cannot connect to the Db2 server.
Have not received expected codepoint: EUSRIDNWPWD. SQLSTATE=HY000 SQLCODE=-1040

The setup I have at the moment is:

• I have created new service credentials and its generated a username, password and host
• Setup some data

Trying to connect to this via ADF using a new linked service (DB2). I have removed the server name intentionally here but its the value I get from the service credential JSON

Answer 1

Hello Conan,

Thank you for the reply.

Can you please check the below prerequisites and confirm they are checked?

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

And please see 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

If this doesn't help, as next steps, we need to collect the network traces for further troubleshooting.