Monitoring Db2 Warehouse On IBM Cloud with Instana

Open Console
Download SSL Certificate
keytool -import -file <Db2.crt> -keystore instana-db2.jks -storepass <store password> -alias instana-db2
cat instana-db2.jks | base64
Add YAML
kind: Secret
apiVersion: v1
metadata:
name: db2-jks
namespace: instana-agent
data:
keystore.jks: >-
<base64 encoded jks>
type: Opaque
kind: DaemonSet
apiVersion: apps/v1
...
namespace: instana-agent
labels:
...
spec:
selector:
...
template:
metadata:
...
spec:
...
containers:
...
env:
...
securityContext:
privileged: true
ports:
- hostPort: 42699
containerPort: 42699
protocol: TCP
imagePullPolicy: Always
volumeMounts:
...
- name: db2truststore <————<<
mountPath: /truststore
terminationMessagePolicy: File
image: 'instana/agent:latest'
...
serviceAccount: instana-agent
volumes:
...
- name: db2truststore <————-<<
secret:
secretName: db2-jks
defaultMode: 420
...
com.instana.plugin.db2:
remote:
- host: '<my db2 host name>'
port: '50001'
tabschema: 'SYSTOOLS'
user: '<my user>'
password: '<my user password>'
sslTrustStorePassword: 'Ins4n4d82'
sslTrustStoreLocation: '/truststore/keystore.jks'
availabilityZone: 'CDL Db2 Monitoring'
poll_rate: 50 # seconds
databases: # multiple databases
- 'BLUDB'
Db2 in Instana
Open dashboard
Db2 moniotoring information

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store