IBM Support

Setting up Maximo Application Server to connect to SSL DB2 Database

Technical Blog Post


Abstract

Setting up Maximo Application Server to connect to SSL DB2 Database

Body

1. In the install_home\maximo\applications\maximo\properties\maximo.properties file, replace the value of the mxe.db.driver property with the new value:

Old: mxe.db.driver=com.ibm.db2.jcc.DB2Driver
New: mxe.db.driver=psdi.server.CustomDriverProxy

2. Create a file named customdriver.properties in the properties folder, like this

    install_home\maximo\applications\maximo\properties\customdriver.properties

3. In the customdriver.properties file, define the name of the driver by adding the following line:

 realdriverclass=com.ibm.db2.jcc.DB2Driver

4. In the customdriver.properties file, add additional properties that you want to specify in the JDBC connection by prepending them with the word property and a period.
For example,

property.sslConnection=true

property.sslTrustStoreLocation=/db2data/images/db210_5_story/FIPS/cert/myapp_client.jks

property.sslTrustStorePassword=changeit

5. Finally, you have to Rebuild and deploy the Maximo EAR files

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11133127