Create Informix databases for schedulers

 

Overview

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

 

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
   

 

Result

The Informix database for scheduler exists.

---

 

See Also

Vendor-specific data sources minimum required settings

 

---