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
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.
java -Djava.ext.dirs=install_root\cloudscape\lib -Dij.protocol=jdbc:db2j: com.ibm.db2j.tools.ij install_root\ProcessChoreographer\createDatabaseCloudscape.ddlOn 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.