Page Comparison

...

...

Preparing DB2 Database

Download the latest version of DB2 Express-C 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

...

Please refer DB2 Express-C Guide for more details on DB2 commands.

Using DB2 Control Center

1. Open the DB2 control center using the command db2cc.

...

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 $GREG_HOME/repository/conf/datasources directory of the deployed registry instance 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 $GREG_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.

$GREG_HOME/dbscripts/db2.sql

Using start-up Parameters

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

...