Creating a Microsoft SQL Server database for process choreographer

This topic describes how to create a Microsoft SQL Server database for process choreographer.

Steps for this task

  1. Make sure that you have administrator rights.
  2. 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.
  3. If your database server is not on the same machine as your application server:
    1. Copy the DDL scripts for your database from the ProcessChroeographer directory on your application server to a suitable directory on your database server machine:
      clearSchemaMsSql2000.ddl
      createDatabaseMsSql2000.ddl
      createSchemaMsSql2000.ddl
      dropSchemaMsSql2000.ddl
    2. Change to the directory where you copied the DDL scripts.
  4. Install an SQL Server, on the machine that will host the database.
    Make sure you select the option to create a case-sensitive instance. If you already have an SQL Server that was created with the case-insensitive option, run the rebuild master tool and change the collation settings to case-sensitive.
  5. Make sure that the database server and the Distributed Transaction Coordinator (DTC) are running.
    To enable XA connections, refer to Vendor-specific data sources minimum required settings for instructions on how to install "Stored Procedures for JTA" from the WebSphere CD.
  6. If you want to create a non-production SQL Server database, named BPEDB, for stand-alone development, evaluation, or demonstration purposes, you only need to enter the following command:
    isql -U userID -P password -i createDatabaseMsSql2000.ddl
    If you want to drop the schema, use the ropSchemaMsSql2000.ddl script.
  7. If you prefer to create your database manually:
    1. Create the database, for example, named BPEDB.
    2. Run the script to create the schema, by entering the following command:
      isql -S serverName -U userID -P password 
           -d databaseName -i createSchemaMsSql2000.ddl
      where:
      userID
      is the user ID to use.
      password
      is the password for userID.
      databaseName
      is the name of the database you created, for example, BPEDB.

Results

The SQL Server database for process choreographer exists.



Searchable topic ID:   t2codbsql
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/t2codbsql.html

Library | Support | Terms of Use | Feedback