Connecting to DB2 databases - ADDM 10.1

You can use BMC Atrium Discovery to connect to IBM DB2 databases, though this does require some additional configuration over that required for the other supported databases. To do this, you need to perform the following steps:

To configure a connection to a DB2 database

To configure a connection to a DB2 database, you must create a custom properties file and copy it and DB2 JAR and license files to the appliance. Creating a properties file is described in Adding new JDBC drivers. An example properties file is shown below.

driver.class=com.ibm.db2.jcc.DB2Driver
driver.name=IBM DB2 driver
driver.url=jdbc:db2://%endpoint%:%port%/%sid%
driver.serverName=%endpoint%
translation.sid=System ID (SID)
translation.endpoint=Database IP Address
validationregex.port=[0-9]+
download.url=
download.label=Driver download page at ibm.com
download.notes=An IBM Account is required.
driver.enabled=true

1. Create the properties file and save it as db2jcc.properties.
2. Copy the db2jcc.properties file to the /usr/tideway/data/custom/jdbcdrivers directory on the appliance.
3. Copy the DB2 JAR file db2jcc.jar to the /usr/tideway/data/custom/jdbcdrivers directory.
4. Copy the DB2 license JAR file, for example, db2jcc_license_cu.jar to the /usr/tideway/java/integrations/lib directory.
5. Restart the tideway service.

Supporting new databases types

Once the JDBC driver is added, you must create a custom pattern with a query definition block. The activation of this pattern allows the creation of credentials for the new database group specified in the custom pattern.

Installing DB2 license jar onto a cluster

Files placed in /usr/tideway/java/integrations/lib are not automatically distributed around a cluster. If using a cluster, the DB2 license jars need to be manually copied to this directory on each cluster member.