Creating a Sybase Adaptive Server Enterprise database for the Business Process Choreographer

Use this task to create a Sybase Adaptive Server Enterprise database for Business Process Choreographer.

Steps for this task

  1. Make sure that you have administrator rights on the machine where you want to install Sybase.
  2. Install the Sybase Adaptive Server Enterprise server, with the Distributed Transaction Management (DTM) option, on the machine that hosts the database.
  3. Copy and configure the Java™ Database Connectivity (JDBC) driver to the following machines:
    • All remote application servers that use the database server.
    • On the deployment manager machine if you are using Network Deployment to administer Business Process Choreographer, for example if you are creating a clustered Business Process Choreographer setup.
  4. Make sure that you configured and enabled the DTM option for Sybase Adaptive Server Enterprise:
    1. Set enable DTM to 1 in the Sybase server configuration.
    2. Set enable xact coordination to 1 in the Sybase server configuration.
    3. Add the dtm_tm_role role to the Sybase administration user ID, for example, user ID sa.
    4. Restart the Sybase server.
  5. On your application server machine, change to the directory where the configuration scripts for Business Process Choreographer are located: On Windows® systems, enter: cd install_root\ProcessChoreographer. On Linux® and UNIX® systems, enter: cd install_root/ProcessChoreographer.
  6. If your database server is not on the same machine as your application server:
    1. Copy the DDL scripts for your database version from the ProcessChroeographer directory on your application server to a suitable directory on your database server machine:
      clearSchemaSybase125.ddl
      createDatabaseSybase125.ddl
      createSchemaSybase125.ddl
      dropSchemaSybase125.ddl
    2. Change to the directory where you copied the DDL scripts.
  7. If you want to create a non-production database, named BPEDB, for stand-alone development, evaluation, or demo purposes, run the script file createDatabaseSybase125.ddl, as described in the file's header.
  8. If you prefer to create your database manually:
    1. Inspect the options that are used in the createDatabaseSybase125.ddl database creation script, and make sure that you include these options in the database you create.
    2. Create the database. For example, named BPEDB.
    3. Create the schema by running the script file createSchemaSybase125.ddl, as described in the file's header.
    4. Make sure that the script output contains no errors. If you want to drop the schema, use the dropSchemaSybase125.ddl script.

Result

The Sybase Adaptive Server Enterprise database for Business Process Choreographer exists.

Copyright IBM Corp. 2003, 2005