Steps for this task
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.
db2 CREATE DATABASE scheddb USING CODESET UTF-8 TERRITORY en-us
db2 connect to scheddb
db2 -tf createTablespaceDB2.ddlMake 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.
db2 -tf createSchemaDB2.ddlMake 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.