Creating a Cloudscape database for process choreographer

Why and when to perform this task

The Cloudscape database system is implemented in the language Java. It comes with the WebSphere Application Server package as several Java Archive (JAR) files (db2j.jar, db2jcc.jar, db2jcc_license_c.jar, db2jtools.jar, db2jcview.jar and db2jnet.jar).

The Cloudscape license that comes with WebSphere Business Integration Server Foundation is only for development and test, not for production purposes. The Cloudscape version that comes with this product includes the Cloudscape Network Server that allows client/server JDBC access over Distributed Relational Database Architecture (DRDA) protocol. Because Cloudscape Network Server has no XA support, process choreographer can only use the Embedded Cloudscape version that can not be accessed remotely. That is why Cloudscape cannot be used as database system for process choreographer in a clustered environment.

To create a Cloudscape database named BPEDB, perform the following:

Steps for this task

  1. Make sure that you have administrator rights on the machine where your application server is installed.
  2. To use a database location other than the default location, either change to the directory where you want the new database created, or edit the createDatabaseCloudscape.ddl script located in the ProcessChoreographer subdirectory of the application server installation directory, and add the fully qualified path to the database name.
    For example, on Windows systems change the line:
    connect 'BPEDB;create=true' as BPEDB;
    to:
    connect 'install_root\ProcessChoreographer\BPEDB;create=true' as BPEDB;

    Note: If you do not use the default location, install_root\ProcessChoreographer\BPEDB, and you will use the business process container install wizard, you must remember to also change the custom properties field when selecting the database. You will have to change the value of the property databaseName to your fully qualified database location.

  3. At the command prompt, enter the command to run the database creation script using the Cloudscape command line processor:
    On Windows systems, enter:
    java -Djava.ext.dirs=install_root\cloudscape\lib
         -Dij.protocol=jdbc:db2j: com.ibm.db2j.tools.ij
         install_root\ProcessChoreographer\createDatabaseCloudscape.ddl
    On UNIX systems, enter:
    java -Djava.ext.dirs=install_root/cloudscape/lib
         -Dij.protocol=jdbc:db2j: com.ibm.db2j.tools.ij
         install_root/ProcessChoreographer/createDatabaseCloudscape.ddl

Results

The Cloudscape database for process choreographer exists.



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

Library | Support | Terms of Use | Feedback