This topic applies only on the z/OS operating system.

Creating DB2 for z/OS databases for schedulers

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

  1. You 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 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.

Results

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



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 8:25:23 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-nd-zos&topic=tsch_codb2forz
File name: tsch_codb2forz.html