IBM DB2 Configuration
- Create the database.
- Add the User for the calendar database.
- Connect to the database as the User created above.
- Using Command Center, open the schema script (cdaily-5.0.0/WEB-INF/sql/IBMDB2/calschema.sql) for DB2 and execute it.
- Using Command Cetner, open the script cdaily-5.0.0/WEB-INF/sql/IBMDB2/passOneElimination.sql. On the validation tab in Command Center, set the statement terminator to ~ and execute the script.
- Configure backup.
- Copy the JDBC Driver files to your application server's path, or the cdaily-5.0.0/WEB-INF/lib directory.
- Configure the JDBC entries in the configuration.properties file
DBObjectClass=com.MHSoftware.db.support.IbmDB2DB
JDBCDriver=com.ibm.db2.jcc.DB2Driver
JDBCConnectString=jdbc\:db2\:CALENDAR
JDBCPassword=calendar
JDBCUserID=calendar