Use this task to create a Sybase Adaptive Server Enterprise database for Business Process
Choreographer.
Steps for this task
- Make sure that you have administrator rights on the machine where
you want to install Sybase.
- Install the Sybase Adaptive Server Enterprise server, with the Distributed Transaction Management
(DTM) option, on the machine that hosts the database.
- 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.
- Make sure that you configured and enabled the DTM option for Sybase Adaptive Server Enterprise:
- Set enable DTM to 1 in the Sybase server configuration.
- Set enable xact coordination to 1 in the Sybase
server configuration.
- Add the dtm_tm_role role to the Sybase administration
user ID, for example, user ID sa.
- Restart the Sybase server.
- 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.
- If your database server is not on the same machine as your application
server:
- 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
- Change to the directory where you copied the DDL scripts.
- 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.
- If you prefer to create your database manually:
- 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.
- Create the database. For example, named BPEDB.
- Create the schema by running the script file createSchemaSybase125.ddl,
as described in the file's header.
- 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.