Previous Topic

Next Topic

Book Contents

Book Index

IBM DB2 Configuration

  1. Create the database.
  2. Add the User for the calendar database.
  3. Connect to the database as the User created above.
  4. Using Command Center, open the schema script (cdaily-5.0.0/WEB-INF/sql/IBMDB2/calschema.sql) for DB2 and execute it.
  5. 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.
  6. Configure backup.
  7. Copy the JDBC Driver files to your application server's path, or the cdaily-5.0.0/WEB-INF/lib directory.
  8. 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

See Also

SQL Database Setup

SQL Database Setup Overview

configuration.properties

Apache Derby Configuration

Microsoft SQL Server 2005-2019 Configuration

MySQL Installation

Oracle Configuration

PostgreSQL Configuration

Sybase Adaptive Server Anywhere Configuration

Converting from One Database to Another