IBM DB2 Configuration

Before you start

Tested with IBM DB2 Express-C 9.7.x
  • Get the IBM Data Server Driver for JDBC and SQLJ from IBM website: https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=swg-idsdjs
  • Copy JDBC driver db2jcc4.jar to webapps/openmeetings/WEB-INF/lib/
  • Create database for OpenMeetings using a pagesize bigger or equal 8K, sample query:
    CREATE DATABASE openmeet AUTOMATIC STORAGE YES ON 'C:' DBPATH ON 'C:' USING CODESET UTF-8 TERRITORY DE COLLATE USING System PAGESIZE 16 K
  • If you encounter issues, you can drop the db and then run the web based installer again

Steps todo

  • Run red5-service and goto the web-based installer: http://localhost:5080/openmeetings/install

DB2 Sample Configuration

There is a sample configuration for IBM DB2 that ships with every release in:
/webapps/openmeetings/WEB-INF/classes/META-INF/db2_persistence.xml