WAS v8.5 > Administer applications and their environment > Welcome to administering Scheduler service > Manage schedulers > Create the database for schedulers > Create scheduler databasesCreate Informix databases for schedulers
This topic describes how to create Informix databases for schedulers, using data definition language (DDL) or structured query language (SQL) files.
To create Informix databases for schedulers, using data definition language (DDL) or structured query language (SQL) files, use these steps.
- Open a command-line window.
- Verify that we have administrator rights for the database system.
- Verify 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.
- 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.
Reference:
Data source minimum required settings, by vendor