Create DB2® databases for scheduler using
data definition language (DDL) or structured query language (SQL)
files.
About this task
To create DB2 databases for scheduler, using
data definition language (DDL) or structured query language (SQL)
files, use these steps.
Procedure
- Open a DB2 command-line window.
- Make sure that you have administrator rights for the database
system.
- 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.
- 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.
Results
The DB2 database for the scheduler exists.