Creating Cloudscape databases for schedulers

This topic describes how to create Cloudscape databases for schedulers using data definition language (DDL) or structured query language (SQL) files.

About this task

To create Cloudscape databases for schedulers, using data definition language (DDL) or structured query language (SQL) files, use these steps.

Procedure

  1. Open a command-line window.
  2. Verify that you have administrator rights for the database system.
  3. Verify that the database supports Unicode (UTF-8). Otherwise, the database does not store all characters that can be handled in Java code, which results in code page conversion problems when a client uses an incompatible code page.
  4. Use the ij utility supplied with the Cloudscape system to create the database. To use ij to create a database called scheddb which is located in /opt, for example, you would do the following:
    ij.sh 
    ij>connect '/opt/scheddb;create=true';
    ij>quit;
    The embedded version of Cloudscape supports only one local connection. If the Application Server product is running and accessing a Cloudscape database, then any attempts to open a second connection to the database from the command line are rejected.
    Note: Add a semi-colon (;) at the end of each command. Otherwise, ij does not execute the command.
  5. Exit the ij utility by issuing the quit command: quit;

Results

The Cloudscape database for the scheduler service exists.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 31, 2013 4:28:44 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-mp&topic=tsch_codbcl
File name: tsch_codbcl.html