+

Search Tips   |   Advanced Search

Create DB2 for z/OS databases for schedulers

Create DB2 for z/OS databases for schedulers using DDL or SQL files.

To create DB2 for z/OS databases for schedulers, using DDL or SQL files, use these steps.

  1. We must have a DB2 subsystem installed in the z/OS platform 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 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 the 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.


Results

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

  • Data source minimum required settings, by vendor