Creating a Cloudscape database for scheduler

Why and when to perform this task

Cloudscape is a database system implemented in Java code. It is delivered with WebSphere Application Server as three Java Archive (JAR) files. The Cloudscape license that comes with WebSphere Application Server is only for development and testing purposed and not for production purposes.

Steps for this task

  1. Open a command-line window.
  2. Make sure that you have administrator rights for the database system.
  3. If you want to use an existing database, skip to step 5.
    Make sure that the database supports Unicode (UTF-8) . Otherwise, it cannot store all characters that can be handled in Java code, and you can run into code page conversion problems when a client uses an incompatible code page.
  4. Use the Cloudview utility supplied with the Cloudscape system to create the database, scheddb.
    Cloudscape supports only one local connection. If WebSphere Application Server is running and accessing a Cloudscape database, then attempts to open a second connection to the database from the command line are rejected.
  5. Create the schema.
    1. Using a text editor, edit the script %WAS_HOME%\Scheduler\createSchemaCloudscape.ddl according to the instruction at the top of the file.
    2. Enter one of the following commands:
      On Windows:
      %install_root%\java\jre\bin\java -Djava.ext.dirs=%install_root%/lib -Dij.protocol=jdbc:db2j: -Dij.database=scheddb com.ibm.db2j.tools.ij %install_root%\Scheduler\createSchemaCloudscape.ddl
      On UNIX:
      %install_root%/java/jre/bin/java -Djava.ext.dirs=%WAS_HOME%/lib -Dij.protocol=jdbc:db2j: -Dij.database=scheddb com.ibm.db2j.tools.ij %WAS_HOME%/Scheduler/createSchemaCloudscape.ddl

Results

The Cloudscape database for the scheduler service exists.



Searchable topic ID:   tsch_codbcl
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/scheduler/tasks/tsch_codbcl.html

Library | Support | Terms of Use | Feedback