DB2 connectivity issue

[monsieurcognos]

Hi,

I'm facing an DB2 and Cognos issue.

Follows the scenario:

I had an database cataloged on server using DB2 SERVER authentication and the data source with a connection to this db already existed and worked fine.

We had to change the database authentication to SERVER_ENCRYPT.

On the server, I can connect to the database by command line successfully. When I test the connection on the data source (on Cognos Administration) it fails showing me the following error:



It was supposed to work, right? But it doesn't.

When I cycle an environment component such as a report dispatcher, it works (when i test the connection on the data source). I believe this happened because content store stores different kind of data including connection and authentication data.

Since we need to make authentication changes on a production server, we just don't want and can't face this issue.

Does anybody know the cause or how to prevent this from happening in the future, please?