Creating a DB2 database for scheduler

Steps for this task

  1. Open a DB2 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: Verify that the database supports Unicode (UTF-8). Otherwise, it cannot store all the characters that can be handled in Java code, and you could run into codepage conversion problems when a client uses an incompatible codepage.

    To avoid deadlocks, be sure that the DB2 isolation level is set to "read stability". If necessary, enter the command db2set DB2_RR_TO_RS=YES then restart the DB2 instance to activate the change.

  4. In the DB2 command line processor, enter this command to create the database:
    db2 CREATE DATABASE scheddb USING CODESET UTF-8 TERRITORY en-us
    A DB2 database named scheddb has been created.
  5. Create the table space and schema.
    1. Analyze the results of your experiences during development and system testing.
      The size of your database depends on many factors. If possible, distribute tablespace containers across different logical disks, and implement an appropriate security policy. Consider the performance implications of your choices for buffer pools and log file settings.
    2. Using a text editor, edit the following scripts according to the instruction at the top of each file: %WAS_HOME%\Scheduler\createTablespaceDB2.ddl, %WAS_HOME%\Scheduler\createSchemaDB2.ddl, %WAS_HOME%\Scheduler\dropSchemaDB2.ddl, and %WAS_HOME%\Scheduler\dropTablespaceDB2.ddl.
    3. Make sure that you are attached to the correct instance.
      Check the environment variable DB2INSTANCE.
    4. To connect to a database named scheddb, enter the command:
      db2 connect to scheddb
    5. To create the table space, enter the command:
      db2 -tf createTablespaceDB2.ddl
      Make sure that the script's output contains no errors. If there were any errors, you can drop the table space using the script dropTablespaceDB2.ddl.
    6. To create the schema (tables and indices), in the DB2 command line processor, enter the command:
      db2 -tf createSchemaDB2.ddl
      Make sure that the script's output contains no errors. If there were any errors, you can use the dropSchemaDB2.ddl file to drop the schema.

Results

The DB2 database for the scheduler exists.



Searchable topic ID:   tsch_codbdb
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_codbdb.html

Library | Support | Terms of Use | Feedback