Create DB2® for z/OS® databases
for schedulers using data definition language (DDL) or structured
query language (SQL) files.
About this task
To create DB2 for z/OS databases
for schedulers, using data definition language (DDL) or structured
query language (SQL) files, use these steps.
Procedure
- You must have a DB2 subsystem installed in the z/OS platform
on a UNIX or Windows machine.
- On the z/OS machine that hosts the database:
- Log on to the native z/OS environment.
- If multiple DB2 systems are installed, then
decide which subsystem you want to use.
- Create a storage group and note the name.
- Decide which user ID is used to connect to the database
from the remote machine running the product. Normally, for security
reasons, this user ID is not the one you used to create the database.
- Grant the user ID the rights to access the database
and storage group. The user ID must also have permission to create
new tables for the database.
- On the server machine:
- Change to the Scheduler subdirectory in the application
server installation root directory.
- Edit the createTablespaceDB2ZOS.ddl script.
Replace @STG@ with the storage group name. Replace @DBNAME@ with
the database name (not the subsystem name), and replace @SCHED_TABLESPACE@ with
the name of a valid tablespace.
- Run your customized version of createTablespaceDB2ZOS.ddl,
as described in the header of the script.
- To avoid deadlocks, verify that
the DB2_RR_TO_RS DB2 flag is set to YES. If necessary,
restart the DB2 instance to activate the change.
Results
The DB2 for z/OS database for the scheduler
service is created.