Installing DXP on IBM DB2 v.10.5

This article documents steps on how to start Liferay DXP on IBM DB2 10.5.

Resolution

Creating a Database

1. Start DB2 Command Line Process Plus.
   
2. Enter the following:
   create database dxp pagesize 32768 USING CODESET UTF-8 TERRITORY US
   1. Note 1: Specify the Territory with the subscriber's specific country.
   2. Note 2: The property temporary tablespace managed by automatic storage is optional. (By default IBM DB2 uses automatic storage and works in most cases, unless there is a storage group.)

• Because of the errors described in the IBM documentation (see below in the Additional Info section), enter the following:
  update database configuration for dxp using LOGFILSIZ 10000
update database configuration for dxp using LOGPRIMARY 80
update database configuration for dxp using LOGSECOND 40
restart database dxp

Note: Substitute the value of dxp for the name of database.
Note: DB2 does not require semi-colons at the end of each command.

---

Connecting the Database

1. Obtain the necessary jars. The jars are available in the \..\IBM\SQLLIB\java folder.
   1. Copy the db2jcc.jar and db2jcc_license_cu.jar into the folder with the other dependencies.
   2. If using Apache Tomcat, place them in the lib\ext folder.
2. Place the db2jcc4.jar in the global lib folder (not in the lib\ext folder or else there will be errors).
3. Enter the following in the portal-ext.properties file:

   jdbc.default.driverClassName=com.ibm.db2.jcc.DB2Driver
   
   jdbc.default.url=jdbc:db2://{IP address}:50000/{database name}:deferPrepares=false;fullyMaterializeInputStreams=true;fullyMaterializeLobData=true;progresssiveLocators=2;progressiveStreaming=2;
   
   jdbc.default.username=db2admin
   
   jdbc.default.password={password}
   		
   
   custom.sql.function.isnull=CAST(? AS VARCHAR(32672)) IS NULL
   
   custom.sql.function.isnotnull=CAST(? AS VARCHAR(32672)) IS NOT NULL
   
   

4. Save the portal-ext.properties file.
5. Start the application server. At this point, Liferay DXP is deployed on IBM DB2 version 10.5

Note: Substitute the value of database's IP address or use localhost.
Note: Substitute the values for the database name, username and password.

Additional Information

• See LPS-53451 for the rationale about the pagesize increase from 8k to 32768.
• See this IBM article on Tuning transaction log characteristics
• See this IBM article on this error: ADM1541W ADM1823E messages and Server crashes