WebSphere Application Server - Express, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Creating DB2 tables for schedulers

Before you begin

This task requires you to configure a database and make it available. See the "Creating DB2 databases for schedulers" topic for more information.

Why and when to perform this task

This topic describes how to create tables for scheduler on DB2 databases, using data definition language (DDL) or structured query language (SQL) files.

Steps for this task

  1. Open a DB2 command-line window.
  2. Verify that you have administrator rights for the database system.
  3. 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 table space 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.
      Note: When setting the table prefix, capitalize all characters.
      %WAS_HOME%\Scheduler\createTablespaceDB2.ddl, %WAS_HOME%\Scheduler\createSchemaDB2.ddl, %WAS_HOME%\Scheduler\dropSchemaDB2.ddl, and %WAS_HOME%\Scheduler\dropTablespaceDB2.ddl. 
    3. Verify that you are attached to the correct instance. Check the environment variable DB2INSTANCE.
    4. To connect to the database, scheddb, for example, and enter the command:
      db2 connect to scheddb
    5. Create the table space. Enter the following command:
      db2 -tf createTablespaceDB2.ddl
      Verify that the script output contains no errors. If there were any errors, you can drop the table space using the following script:
      dropTablespaceDB2.ddl
    6. To create the schema (tables and indices), in the DB2 command line processor, enter the command db2 -tf createSchemaDB2.ddl. Verify that the script output contains no errors. If there were any errors, you can use the following file to drop the schema:
      dropSchemaDB2.ddl
    7. Verify that the DB2_RR_TO_RS DB2 flag is set to YES to avoid deadlocks. Restart the DB2 instance to activate the change, if needed.

Result

The DB2 tables and schema for the scheduler exist.



Related tasks
Creating DB2 databases for schedulers

Related reference
DB2 tuning parameters
Vendor-specific data sources minimum required settings

Task topic    

Terms of Use | Feedback

Last updated: Jun 8, 2005 12:45:23 PM EDT
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r0/index.jsp?topic=/com.ibm.websphere.express.doc/info/exp/scheduler/tasks/tsch_dbtuadmin.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)