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

Creating DB2 databases for schedulers

Why and when to perform this task

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

Steps for this task

  1. Open a DB2 command-line window.
  2. Make sure that you have administrator rights for the database system.
  3. Verify that the database supports Unicode (UTF-8). Otherwise, it cannot store all the characters that can be handled in Java code, which might result in code page conversion problems, when a client uses an incompatible code page.
    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 with an example name, scheddb:
    db2 CREATE DATABASE scheddb USING CODESET UTF-8 TERRITORY en-us
    A DB2 database named scheddb has been created.

Result

The DB2 database for the scheduler exists.



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

Task topic    

Terms of Use | Feedback

Last updated: Mar 17, 2005 4:28:29 AM CST
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/scheduler/tasks/tsch_codbdb.html

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