Creating a Sybase Adaptive Server Enterprise database for the process choreographer

This topic describes how to create a Sybase Adaptive Server Enterprise database for 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 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 process choreographer, for example if you are creating a clustered 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 process choreographer are located:
    On Windows systems, enter: cd install_root\ProcessChoreographer. On 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:
      For Sybase 12.0: For Sybase 12.5:
      clearSchemaSybase120.ddl
      createDatabaseSybase120.ddl
      createSchemaSybase120.ddl
      dropSchemaSybase120.ddl
      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, you only need to enter the command:
    isql -S serverName -U userID -P password
         -i createDatabaseSybaseXXX.ddl
    where
    serverName
    The name of the Sybase server, that you defined with the dsedit tool.
    userID
    The user ID to use.
    password
    The password for userID.
    XXX
    The three digit number based on your Sybase version number: Either120 for version 12.0, or 125 for version 12.5.
  8. If you prefer to create your database manually:
    1. Inspect the options used in the createDatabaseSybaseXXX.ddl quick 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. Run the script to create the schema, by entering the command:
      isql -S serverName -U userID -P password
           -D databaseName -i createSchemaSybaseXXX.ddl
      where
      serverName
      The name of the Sybase server, that you defined with the dsedit tool.
      userID
      The user ID to use.
      password
      The password for userID.
      databaseName
      is the name of the database.
      XXX
      The three digit number based on your Sybase version number: Either120 for version 12.0, or 125 for version 12.5.
    4. Make sure that the script output contains no errors.
      If you want to drop the schema, use the dropSchemaSybaseXXX.ddl script.

Results

The Sybase Adaptive Server Enterprise database for process choreographer exists.



Searchable topic ID:   t2codbsz
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/workflow/tasks/t2codbsz.html

Library | Support | Terms of Use | Feedback