Maximo Application Suite Customer-managed

Suite applications cannot connect to Db2 Warehouse databases

After Cloud Pak for Data and the Db2® Warehouse service are upgraded, Suite applications cannot connect to databases because the security certificates are no longer valid.

Symptom

After you upgrade Cloud Pak for Data and Db2 Warehouse to the versions that are required by version 8.7.0 of the Suite, some Suite applications cannot connect to Db2 Warehouse databases.

Cause

When you upgrade Cloud Pak for Data and the corresponding Db2 Warehouse service, the Db2 Warehouse SSL certificates are refreshed. As a result, the Suite's Java database connection (JDBC) configuration is invalidated.

Resolution

  1. In the Cloud Pak for Data dashboard menu, download the new SSL certificate by clicking Databases > Db2 instance details > Download SSL Certificate.
  2. In the Maximo® Application Suite administration dashboard, click Configurations > > Database connection and select the connection that you want to update.
  3. Click Edit and paste the content of the new certificate.
  4. Click Confirm, reenter the connection's username and password, and save your changes. The Suite operator identifies this update and ensures that the new certificate is added to the Suite's truststore.
  5. After the certificate is added to the truststore, connect to your Red Hat® OpenShift® cluster by using the web console.
  6. In the openshift-operators namespace, delete the service-binding-operator pod. This step ensures that the new SSL certificate is updated across all Suite applications.