Creating secure JDBC connections for Performance Warehouse

Follow these steps to create a secure JDBC connection from your PE Client to Performance Warehouse.

Procedure

Edit the JDBC string to include the following parameters:
  • sslConnection=true
  • sslCertLocation=<certificate_location>

For example, for a system name DS01 with a secure port 4000 and monitored Db2 subsystem DB1A, the JDBC string would be modified as follows:

jdbc:db2://DS01:4000/DS01DB1A:sslConnection=true;sslCertLocation=C:\\temp\\DB2.CERTAUTH.CERTB64

If you store your certificates in a TrustStore, then you must specify the following JDBC parameters (instead of sslConnection and sslCertLocation):

  • sslTrustStoreLocation=<truststore_location>
  • sslTrustStorePassword=<password>

For more information, see https://www.ibm.com/docs/en/db2/11.5?topic=sqlj-data-server-driver-jdbc-support-ssl