Create DB2 databases for schedulers

 

Overview

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

 

Procedure

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.

---

 

See Also

DB2 tuning parameters
Vendor-specific data sources minimum required settings

 

---