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 again and delete the file $red5/webapps/openmeetings/conf/install.xml and then run the web based installer again

Steps todo

  • Rename:
    $red5/webapps/openmeetings/WEB-INF/classes/META-INF/db2_persistence.xml
    to
    $red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
  • Prepare Database Settings - go to openmeetings_version_no_xx/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
    Alter config values in persistence.xml connectionURL, username and password with your values
  • 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