DB2 AS400 to Azure Data Factory V2

George Quevin 0

I have a self hosted integration runtime on a VM which has access to DB2 AS/400.

When trying to create a linked server using this integration runtime it returns error

"Cannot connect to the Db2 server. The host resource could not be found. Check that the Initial Catalog value matches the host resource name. SQLSTATE=HY000 SQLCODE=-360 Activity"

Microsoft Oledb for DB2 is installed in the VM, I also added the IP to hosts file but no success.

This article doesn't mention AS/400 as supported and for what I saw, it was on ADF V1 but no longer on V2.

Anil Kumar Raju A 0 Reputation points

2023-06-02T04:53:40.4066667+00:00

To connect to a DB2 AS/400 database from Azure Data Factory v2 using a self-hosted integration runtime, you can follow these steps:

Ensure that you have the necessary prerequisites installed on the VM where the self-hosted integration runtime is installed. This includes the Microsoft OLE DB Provider for DB2.

Verify that the DB2 AS/400 server is accessible from the VM where the integration runtime is running. Ensure that there are no network connectivity issues, firewalls blocking the connection, or any other restrictions that might prevent the VM from reaching the DB2 AS/400 server.

Double-check the connection details and parameters used when creating the linked server in Azure Data Factory. Make sure that the Initial Catalog value matches the host resource name of the DB2 AS/400 server. This value is typically the name of the database you want to connect to.

Ensure that the login credentials provided in the linked server configuration have sufficient privileges to connect to the DB2 AS/400 database. Check if the username and password are correct and have the necessary permissions to access the desired database.

If you have already added the IP address of the DB2 AS/400 server to the hosts file on the VM, verify that the IP address is correct and that there are no typos or formatting issues in the hosts file entry.

If the issue persists, consider checking the compatibility of the DB2 AS/400 server with the Microsoft OLE DB Provider for DB2. Ensure that the versions are compatible and that any necessary updates or patches are applied to the server or the provider.

If none of the above steps resolve the issue, consider reaching out to Azure support for further assistance. They can help investigate the specific error message and provide guidance based on your environment and configuration.

It's worth noting that while DB2 AS/400 may not be explicitly mentioned as a supported data source in the Azure Data Factory documentation, it is still possible to connect to it using the appropriate integration runtime and connectivity options.
BhargavaGunnam-MSFT 25,881 Reputation points Microsoft Employee

2023-06-06T22:07:39.7466667+00:00

Hello George Quevin ,

I am checking to see if you got a chance to look into my earlier response. Please let us know if you have any further questions.

1 answer

BhargavaGunnam-MSFT 25,881 Reputation points Microsoft Employee

2023-06-02T23:25:06.5966667+00:00

Hello George Quevin ,

Welcome to the MS Q&A platform.

Did you get a chance to look into the Data Provider Error Codes document?

https://learn.microsoft.com/en-us/host-integration-server/db2oledbv/data-provider-error-codes#drda-protocol-errors

can you please test whether you can connect to DB2 from the SHIR machine using the same connection string?

Can you please test the linked service connection using the ODBC link service? https://docs.microsoft.com/en-us/azure/data-factory/connector-odbc.

Please let me know if you have any further questions.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment