integrating liferay with DB2

Integratinging Liferay with DB2

Install DB2

Import SQL file into DB2

db2 -td\; -vf create-db2.sql

Install JDBC drivers
Install jdbc driver files db2jcc.jar and db2jcc_license_cu.jar into directory $TOMCAT_HOME/lib/ext 

Edit tomcat/lib/portal-ext.properties file and add following lines.

***************************

hibernate.dialect=com.liferay.portal.dao.orm.hibernate.DB2Dialect

custom.sql.function.isnull=CAST(? AS VARCHAR(32672)) IS NULL

custom.sql.function.isnotnull=CAST(? AS VARCHAR(32672)) IS NOT NULL

jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver

jdbc.default.url=jdbc:db2://127.0.0.1:50000/lportal

jdbc.default.username=

jdbc.default.password=