Create Informix databases for schedulers

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

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

1. Open a command-line window.

2. Verify that we 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. 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.

Data source minimum required settings, by vendor