Creating a Sybase 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. Make sure that you have the DTM option for Sybase ASE installed.
  4. If you want to use an existing database, skip to step 6.

    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.

  5. Use the Sybase isql utility to create a database named scheddb. See your Sybase product documentation for details.
  6. Create the schema:
    1. Using a text editor, edit the following script <install_root>\Scheduler\createSchemaSybase12.ddl according to the instruction at the top of the file.
    2. Enter the command:
      isql -S <serverName> -U<userid> -P<password> -D scheddb -i createSchemaSybase12.ddl

Results

The Sybase database for the scheduler exists.



Searchable topic ID:   tsch_codbsz
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_codbsz.html

Library | Support | Terms of Use | Feedback