DB2 Database Configuration

 

The instructions below describe how to configure DB2 to work with the WebSphere Application Server Samples.

Create the SAMPLE Database

  1. Create an operating system user named wsdemo with a password of wsdemo1. Use all lower case letters when creating the wsdemo user. The wsdemo user does not require special privileges.
  2. Create the SAMPLE database:

Create the Sample Data Source Object

  1. Point your browser to the WebSphere Application Server Administrative Console:
    http://localhost:9090/admin.
  2. Update the DB2 JDBC Driver, if necessary:
  3. Create the Sample DataSource Object:

Remove the Samples IDB DataSource Object

  1. Point your browser to the WebSphere Application Server Administrative Console:
    http://localhost:9090/admin.
  2. Expand Resources > JDBC Drivers > idbJdbcDriver and click Data Sources.
  3. Check the box next to Samples IDB DataSource and click Delete.
  4. Save your configuration.
  5. Shutdown and restart the WebSphere Application Server.

Run the Database Servlet

Run the servlet to create and configure the tables in the SAMPLE database.