59169-db2errorlog-ssma.log Attaching the error log for your reference. Does SSMA (mentioned version in the log) support connectivity to IBM Bluemix DB2 connectivity? Does SSMA support or provide option to connect DB2 database which is SSL enabled? if yes, please share how can we connect to DB2 database which is only accepting SSL connections.

Hello, We never tested SSMA with DB2 running on Bluemix, but from what I understand, Bluemix is IBM's Cloud offering, where they appear to be running LUW version, which is supported by SSMA. Unless there are changes they've made to catalog views or access model - it should work. As to SSL - this is not really an SSMA problem, but rather a configuration for the OLE DB provider you are using to connect. It appears that you are using "Microsoft DB2 OLE DB Provider". The easiest way to craft correct connection string and test the connection would be to use the Data Access Tool . You may want to provide "Certificate Common Name" to enable SSL/TLS in the provider. Regards, Alex.

SSMA connectivity to DB2 ( with SSL enabled on IBM Bluemix platform ) is failing. Does SSMA support this type of connection to DB2 database?

Siddhesh Manjrekar 1

59169-db2errorlog-ssma.log
Attaching the error log for your reference.

Does SSMA (mentioned version in the log) support connectivity to IBM Bluemix DB2 connectivity?
Does SSMA support or provide option to connect DB2 database which is SSL enabled? if yes, please share how can we connect to DB2 database which is only accepting SSL connections.

1 answer

Alexander Ivanov 491 Reputation points

2021-01-21T21:05:33.597+00:00

Hello,

We never tested SSMA with DB2 running on Bluemix, but from what I understand, Bluemix is IBM's Cloud offering, where they appear to be running LUW version, which is supported by SSMA. Unless there are changes they've made to catalog views or access model - it should work.

As to SSL - this is not really an SSMA problem, but rather a configuration for the OLE DB provider you are using to connect. It appears that you are using "Microsoft DB2 OLE DB Provider". The easiest way to craft correct connection string and test the connection would be to use the Data Access Tool. You may want to provide "Certificate Common Name" to enable SSL/TLS in the provider.

Regards,
Alex.
Please sign in to rate this answer.
Siddhesh Manjrekar 1 Reputation point

2021-01-22T06:48:05.773+00:00

Thanks for the response. Earlier, we received different response on below similar thread. Can you please validate on this?

https://video2.skills-academy.com/en-us/answers/questions/116114/connectivity-to-source-db2-database-via-ssma-for-d.html

Right now, only OLEDB provider option is available when we connect to DB2 in SSMA tool and we can change it. When you mentioned - you are using "Microsoft DB2 OLE DB Provider" - Do we have any other alternative here? If yes, please share the details of configuration.

Siddhesh Manjrekar 1 Reputation point

2021-01-25T15:42:58.273+00:00

@Alexander Ivanov @CathyJi-MSFT

Thanks for you for the response. I have built the connection string using data access tool and used it for DB2 LUW connection string mode to connect to IBM Bluemix DB2 (It is DB2 on Linux confirmed by IBM). However I am still getting below error.

Error:
Connection to DB2 failed.
The user does not have the authority to access the host resource. Check your authentication credentials or contact your system administrator.

Can you pls advise on this error? We are also informed that dbadmin privileges were given to the user id used and certificated used is self signed one here.

Alexander Ivanov 491 Reputation points

2021-01-25T16:24:47.777+00:00

Hello,

I don't see any discrepancies in two answers provided - we do not officially support DB2 in IBM Cloud and we never tested this scenario. I was merely saying if it is LUW, then it might work.
You can use any OLE DB driver of your choice when in Connection string mode. According to the documentation of the driver you are using, this is indeed a problem with credentials.

Regards,
Alex.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SSMA connectivity to DB2 ( with SSL enabled on IBM Bluemix platform ) is failing. Does SSMA support this type of connection to DB2 database?

1 answer

Your answer