Creating Informix databases for schedulers

Create Informix® databases for schedulers using data definition language (DDL) or structured query language (SQL) files.

About this task

To create Informix 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 the Java™ code, which results in code page conversion problems, when a client uses an incompatible code page.
  4. If you want to create a new database named scheddb, for example, enter the command:
    dbaccess CREATE DATABASE scheddb with log

Results

The Informix database for scheduler exists.