Setting up with IBM DB2

Follow the instructions below to set up the IBM DB2.

Preparing DB2 Database

Download the latest version of DB2 Express-C (http://www-01.ibm.com/software/data/db2/express/download.html) and install it on your computer.

Setup Database and Users

Using DB2 Command Processor

1. Run DB2 console. Run db2start in command line to open the DB2

db2=> db2start

2. Create the database.

db2=> create database DB_NAME

3. Before you can issue an SQL statement, you have to connect to a database. Establish the connection:

db2=> connect to DB_NAME user USER_NAME using PASSWORD

4. Grant required permissions for users.

db2=> connect to DB_NAME
db2=> grant AUTHORITY on database to user USER_NAME

(AUTHORITY : SYSADM,SYSCTRL,SYSMAINT,SYSMON,DBADM or LOAD)

For example,

For more information on DB2 commands, refer to DB2 Express-C Guide at: http://www.ibm.com/developerworks/wikis/display/db2/free+book-+getting+started+with+db2+express-c.

Using DB2 Control Center

1. Open the DB2 control center using the command db2cc. For example,

2. Create a new database. Right click the "All Databases" entry in the Control center tree (inside the object browser) and click "Create Database"-->"Standard". Follow the steps in the "Create new Database" wizard.

3. Create the new database users from "User and Group Objects" entry for your newly created database.

4. Give required permissions to newly created users.

Setup Configuration Files

1. Edit the default database configuration defined in the  master-datasources.xml  file located at  $CARBON_HOME/repository/conf/datasources  directory as below. Both the database configurations in  registry.xml  and  user-mgt.xml  refer this data source.

<datasource>
      <name>WSO2_CARBON_DB</name>
      <description>The datasource used for registry and user manager</description>
      <jndiConfig>
            <name>jdbc/WSO2CarbonDB</name>
      </jndiConfig>
      <definition type="RDBMS">
            <configuration>
                <url>jdbc:db2://SERVER_NAME:PORT/DB_NAME</url>
                <username>regadmin</username>
                <password>regadmin</password>
                <driverClassName>com.ibm.db2.jcc.DB2Driver</driverClassName>
                <maxActive>80</maxActive>
                <maxWait>360000</maxWait>
                <minIdle>5</minIdle>
                <testOnBorrow>true</testOnBorrow>
                <validationQuery>SELECT 1</validationQuery>
                <validationInterval>30000</validationInterval>
            </configuration>
      </definition>
</datasource>

The database configuration options

• url - The URL of the database.

• username - The name of the database user.

• password - The password of the database user.
• driverClassName - The class name of the database driver.
• maxActive - The maximum number of active connections that can be allocated from this pool at the same time or negative for no limit.
• maxWait - The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception, or <= 0 to wait indefinitely.
• minIdle - The minimum number of active connections that can remain idle in the pool without extra ones being created or 0 to create none.

Setup DB2 jdbc Drivers

Copy the DB2 jdbc Drivers ( db2jcc.jar and db2jcc_license_c0u.jar) from $DB2_HOME\SQLLIB\java to $CARBON_HOME/repository/components/lib directory.

Create Database Tables

Database tables can be created either manually by running scripts or automatically by using start-up parameters.

Using Scripts

Database tables can be created manually by executing the following script in DB2 Express C command editor.

$CARBON_HOME/dbscripts/db2.sql

Using start-up Parameters

Database tables can be created when starting WSO2 ESB for the first time using the startup parameters as follows.

• For Windows:

  $CARBON_HOME/bin/wso2server.bat -Dsetup
  

• For Linux:

  $CARBON_HOME/bin/wso2server.sh -Dsetup