Page Comparison

...

...

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

...

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,

...

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 BPS for the first time using the startup parameters as follows.

...