[Version 5.0.1 and later]Creating a Microsoft SQL Server database for scheduler

Steps for this task

  1. Open a command-line window.
  2. Change to the directory where the configuration scripts for scheduler are located. This is the Scheduler subdirectory of the IBM WebSphere Application Server installation directory.
    On Windows, enter:
    cd %WAS_HOME%\Scheduler
    On UNIX, enter:
    cd $WAS_HOME/Scheduler
  3. Using a text editor, edit the schema creation script (createSchemaMSSQL.sql for SQL Server 2000), according to the instructions at the beginning of the file.
  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. If you want to create a new database named scheddb:
    1. Make sure that you are using a user ID that has administrator rights for the database system.
    2. In the Enterprise Manager, expand a server group, then expand a server.
    3. Right-click Databases, then click New Database.
    4. Type the name scheddb.
    5. Modify any default values, as desired, then save.
    A Microsoft SQL Server database named scheddb is created.
  6. To create the schema:
    1. Make sure that you have administrator rights for the database system.
      The user ID you use to create the schema must be the one that you tell WebSphere Application Server to use when accessing the database.
    2. Run the script to create the schema (tables and views):
      isql -S <serverName> -U<userid> -P<password> -D<databaseName> -i <script name>

Results

The Microsoft SQL Server database for scheduler exists.



Searchable topic ID:   tsch_codbsql
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_codbsql.html

Library | Support | Terms of Use | Feedback