Setting up Maximo Application server to use IBM DB2® pureScale™

Body

Do you have requirements to make your Maximo DB scalable or highly available?
If so, using IBM DB2® pureScale™ and it's clustering technology can help you achieve high availability and scalability for your Maximo environment.

IBM DB2® pureScale™ is certified for use with Maximo Asset Configuration Management 7.5.0.1. You must configure your database server manually, and then install Maximo Asset Management 7.5.0.1 by following the instructions in the Installation Guide to deploy manually reusing existing middleware.

After you install the product, configure this properties to implement IBM DB2® pureScale™.

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. (Optional) 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, to add the property enableSysplexWLB, add the following line:

 property.enableSysplexWLB=true

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

For more information about

+ General topic
http://pic.dhe.ibm.com/infocenter/tivihelp/v49r1/index.jsp?topic=%2Fcom.ibm.mbs.doc%2Fgp_highavail%2Fc_ctr_high_availability.html

+ PureScale info
http://pic.dhe.ibm.com/infocenter/tivihelp/v49r1/topic/com.ibm.mbs.doc/gp_highavail/t_configure_db2_purescale.html

I hope you like this article, feel free to share your experiences.

Alessandra Lima Aguiar (limaa@br.ibm.com)