Creating an Informix database for scheduler

Steps for this task

  1. Open a command-line window.
  2. Make sure that you have administrator rights for the database system.
  3. If you want to use an existing database, skip to step 5.

    Note: Make sure that the database supports Unicode (UTF-8) . Otherwise, it cannot store all characters that can be handled in the Java code, and you could run into codepage conversion problems when a client uses an incompatible codepage.

  4. If you want to create a new database named scheddb, enter the command:
    dbaccess CREATE DATABASE scheddb with log
  5. Create the schema.
    1. Using a text editor, edit the script %WAS_HOME%\Scheduler\createSchemaInformix.sql according to the instruction at the top of the file.
    2. Enter the command:
      dbaccess scheddb createSchemaInformix.sql

Results

The Informix database for scheduler exists.



Searchable topic ID:   tsch_codbinf
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/scheduler/tasks/tsch_codbinf.html

Library | Support | Terms of Use | Feedback