Create DB2 for z/OS databases for schedulers

 

Overview

This topic describes how to create DB2 for z/OS databases for schedulers using data definition language (DDL) or structured query language (SQL) files.

 

Procedure

  1. You must have already installed on a UNIX or Windows machine.

  2. On the z/OS machine that hosts the database:

    1. Log on to the native z/OS environment.

    2. If multiple DB2 systems are installed, then decide which subsystem you want to use.

    3. Create a storage group and note the name.

    4. 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.

    5. 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.

  3. On the server machine:

    1. Change to the Scheduler subdirectory in the application server installation root directory.

    2. 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.

    3. Run your customized version of createTablespaceDB2ZOS.ddl, as described in the header of the script.

    4. 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.

 

Result

The DB2 for z/OS database for the scheduler service is created.

 

See Also


Vendor-specific data sources minimum required settings