IBM Support

How to setup DB2 sensor to monitor DB2 on Cloud with SSL enabled

How To


Summary

How to configure the DB2 sensor when SSL is enabled on DB2 is reported here:
https://www.ibm.com/docs/en/instana-observability/current?topic=technologies-monitoring-db2#ssltls-support
and here with some more details:
https://medium.com/@n.shibu/monitoring-ssl-enabled-db2-by-using-instana-4c08a11d5ab6

This article is to add some details to the standard configuration of the DB2 sensor in the scenario where DB2 is on Cloud and instana-agent is in kubernetes.

Steps

Basically the first step is to download the SSL certificate (a crt file) from DB2 on Cloud.
Then you need to create a jks file using a keytool command like the following:
 
keytool -import -alias testalias -file test.crt -keypass keypass -keystore test.jks -storepass test@123
 
where with the -storepass switch, you specify the password which is the one you use in sslTrustStorePassword in the configMap/configuration.yaml.
Then you need to upload the jks file into the instana-agent secret specifying a directory of your choice, eg /truststore and this is the directory that is specified for sslTrustStoreLocation in configMap/configuration.yaml.
 
Finally you need to restart the instana-agent pods to make the changes effective.
 
This has made the trick, db2 sensor could connect to DB2 and metrics have appeared in Instana UI.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSE1JP5","label":"IBM Instana Observability"},"ARM Category":[{"code":"a8m3p000000UoUBAA0","label":"Sensors - Setup \u0026 Discovery"}],"ARM Case Number":"TS013882481","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
29 September 2023

UID

ibm17042152