Configuring a DB2 database

Before you install the server, install the DB2 database and provide the JDBC JAR file for the installation process.

Before you begin

Before you install the IBM® UrbanCode Deploy server, install DB2 version 9.7 or later. If you are evaluating IBM UrbanCode Deploy, you can install the database on the same server as the IBM UrbanCode Deploy server.

When you install IBM UrbanCode Deploy, you need the DB2 connection information and a user account with table creation privileges.

Procedure

  1. Create a database with a default page size of 32 K.
  2. Obtain the DB2 JDBC driver. The JDBC JAR file is included among the installation files for the database. The driver is unique to the edition you are using.
  3. Copy the JDBC JAR file to installer_directory\lib\ext.
  4. Before you run the server installation, edit the file ibm-ucd-install/database/deploy/ud-foreign-keys.ddl to add the following line of code:
    SET CURRENT RULES = 'STD';
  5. Begin server installation, see Installing the server. When you are prompted for the database type, enter db2.
  6. Provide the JDBC driver class IBM UrbanCode Deploy uses to connect to the database. The default value is com.ibm.db2.jcc.DB2Driver.
  7. Next, provide the JDBC connection string. Typically, it is similar to the following code:
    jdbc:db2://DB_URL:DB_PORT/DB_NAME
    For example:
    jdbc:db2://localhost:50000/ibm_ucd
  8. Finish by entering the database user name and password.

Feedback