Setting up the database

In order to demonstrate create, restore, update, and delete operations and true metadata-driven design, the TwineBall server uses an actual database to define its entities and store its data. This necessitates some additional setup. Scripts have been provided to make this easier, but these scripts will require some slight modification to match your system.

To set up the database, follow these steps.

  1. Install the WebSphere Business Integration Adapter Framework or WebSphere InterChange Server and all their pre-requisites.
  2. Install IBM DB2 Version 8, Fix pack 2.
  3. Create the following user ids in your operating system:
    TwineBall, TwineBallAdapter.
    Give them the password
    sample42
       
  4. Create the Twine database. In the setup/SQL directory, you'll find Twine-database.bat and Twine-database.sql.
    Edit Twine-database.sql to match your password for the db2admin id.
  5. Run the Twine-database.bat script. You should not receive any error messages. If you do, resolve them before continuing.
  6. Create the tables needed by the TwineBall server. In the setup/SQL directory, you'll find TwineBall-Schema.bat and TwineBall-Schema.SQL.
  7. Run the TwineBall-Schema.bat script. Resolve any errors before continuing.
  8. Set up the Event and Archive tables. In the setup/SQL directory, you'll find WBIA-Events.sql and WBIA-Events.bat.
  9. Run the WBIA-Events.bat script. Resolve any errors before continuing.

Copyright IBM Corp. 1997, 2004