Configuring a DB2 database

You can use DB2® database as a supporting database with the IBM® UrbanCode Release server.

About this task

When you install IBM UrbanCode Release, you need the database connection information and the JDBC JAR file. The user account for the database must have table creation privileges.

Procedure

  1. Create a database named ibm_ucr with the maximum page size:
    CREATE DATABASE ibm_ucr USING CODESET UTF-8 TERRITORY US PAGESIZE 32768;
  2. Obtain the DB2 JDBC driver JAR file for the edition of DB2 that you are using. This file must be available when you run IBM Installation Manager.
  3. Record the values of the database parameters so that you can supply them when you install the server. The following parameters are typical for an installation of DB2 database that is used to support IBM UrbanCode Release:
    Parameter Value
    Database user name db2inst1
    Database password user_account_password
    Database driver class com.ibm.db2.jcc.DB2Driver
    Database connection string jdbc:db2://database_server:50000/ibm_ucr

Feedback