WebSphere Application Server Network Deployment, Version 6.0.x     Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Creating DB2 for z/OS databases for schedulers

Why and when to perform this task

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

Steps for this task

  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.



Related reference
Vendor-specific data sources minimum required settings

Task topic    

Terms of Use | Feedback

Last updated: Mar 17, 2005 4:28:29 AM CST
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.nd.doc/info/ae/scheduler/tasks/tsch_codb2forz.html

© Copyright IBM Corporation 2002, 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)