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
- Open a command-line window.
- Verify that you have administrator rights for the database system.
- 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.
- 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.
- Exit the ij utility by issuing the quit command: quit;
Results
The Cloudscape database for the scheduler service exists.