This topic describes how to 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.