Configuring WebSphere Application Server for DB2 manually

IBM Worklight V5.0.5. automatically configures your databases. However, if you are using an older version of IBM Worklight, or if you are experiencing problems with the automatic configuration process for the WebSphere Application Server, you must manually set up and configure your DB2 database and then the WebSphere Application Server for DB2. Complete the DB2 Database Setup procedure before continuing.

  1. Set up the JDBC provider:

    1. In the WebSphere Application Server console, click Resources > JDBC > JDBC Providers > New.

    2. Set the scope of the JDBC connection to Node level.

    3. Set Database type to DB2.

    4. Set Provider type to DB2 Universal JDBC Driver Provider.

    5. Set Implementation Type to Connection pool data source.

    6. Set Name to DB2 Universal JDBC Driver Provider.

    7. Click Next.

    8. Set the directory location for DB2 to DB2_HOME/java, where DB2_HOME is the directory where DB2 is installed.

    9. Do not set Native library path.

    10. Click Next.

    11. Click Finish.

    12. The JDBC provider is created.

    13. Click Save.

  2. Create a data source for the IBM Worklight database:

    1. Select the new JDBC provider and click Data Source.

    2. Click New to create a data source.

    3. Set the Data source name to Worklight Database.

    4. Set JNDI Name to jdbc/WorklightDS.

    5. Click Next.

    6. Enter properties for the datasource: For example, Driver type: 4, Database Name: WRKLGHT, Server name: localhost, Port number: 50000 (default). Leave “Use this data source in (CMP)” checked;

    7. Click Next.

    8. Create JAAS-J2C authentication data, specifying the DB2 user name and password for Container Connection.

    9. Select the component-managed authentication alias that you created.

    10. Click Next and Finish.

    11. Click Save.

  3. Create a data source for the IBM Worklight reports database:

    1. Select the new JDBC provider and click Data Source.

    2. Click New to create a data source.

    3. Set the Data source name to Worklight Reports Database.

    4. Set JNDI Name to jdbc/WorklightReportsDS.

    5. Click Next.

    6. Select the component-managed authentication alias that you created.

    7. Click Next and Finish.

  4. Test the data source connection by selecting each Data Source and clicking Test Connection.


Parent topic Troubleshooting