Creating a DB2 UDB for z/OS database for process choreographer

Why and when to perform this task

This topic describes how to create a DB2 UDB for z/OS database and how to verify that it is reachable from the application server machine.

Steps for this task

  1. You must have already installed WebSphere Business Integration Server Foundation on a UNIX, Linux, or Windows machine.
  2. On the z/OS machine that hosts the database:
    1. Log on the native z/OS environment.
    2. If multiple DB2 systems are installed, decide which subsystem you want to use.
    3. Make a note of the IP port to which the DB2 subsystem is listening.
    4. Using the DB2 administration menu, create a new database, for example, named BPEDB. Note the name of the database.
    5. Create a storage group and note the name.
    6. Decide which user ID is used to connect to the database from the remote machine running WebSphere Application Server. Normally, for security reasons, this user ID is not the one that you used to create the database.
    7. 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.
    8. Decide if you want to create the tables and views in the schema of the connected user ID or if you want to customize the schema qualifier (SQLID). If a single user ID accesses multiple databases with tables of the same name, you must use different schema qualifiers to avoid name collisions.
  3. On the Application Server machine:
    1. Make sure that you have DB2 Connect Gateway (Version 8.1 Fix Pack 3 or later) installed. This component is part of the DB2 UDB ESE package, but you can also install it separately.
    2. Catalog the remote database using the following commands in a DB2 command line window:
      catalog tcpip node zosnode remote host_name server IP_port ostype mvs
      catalog database subsystem as subsystem at node zosnode authentication dcs
      catalog dcs database subsystem as subsystem parms ',,INTERRUPT_ENABLED'
    3. Take note of the following:

      An important difference exists between DB2 UDB and DB2 UDB for z/OS. DB2 UDB does not have the concept of a subsystem, but DB2 UDB for z/OS does. To avoid confusion between database name and subsystem name, it is important to understand that because DB2 UDB for z/OS runs in a subsystem, the catalog node and catalog database commands must identify the appropriate subsystem. On DB2 UDB, the subsystem name is not a known concept, so the database name that the catalog command makes a link to is really the name of the DB2 UDB for z/OS subsystem.

    4. Verify that you can establish a connection to the remote subsystem by entering the following command:
      db2 connect to subsystem user userid using password
    5. Change to the ProcessChoreographer subdirectory in the installation root directory of the application server.
    6. Edit the createTablespaceDb2V7zOs.ddl script. Replace @STG@ with the storage group name and replace @DBNAME@ with the database name (not the subsystem name).
    7. Run your customized version of the createTablespaceDb2V7zOs.ddl script, as described in the header of the script.
      If you want to drop the table space, use the dropTablespaceDb2V7zOs.ddl script.
    8. Edit the createSchemaDb2V7zOs.ddl script.
      1. Replace @STG@ with the storage group name.
      2. Replace @DBNAME@ with the database name (not the subsystem name).
      3. Replace @SQLID@ with the schema qualifier or remove @SQLID@ (including the following dot) from the script. A custom schema qualifier can only be used with the DB2 Universal JDBC driver and requires that the configuration property customSQLID be set to the appropriate value.
    9. Run your customized version of the createSchemaDb2V7zOs.ddl script, as described in the header of the script.
      If this script does not work, or if you want to remove the tables and views, use the dropSchemaDb2V7zOs.ddl script to drop the schema.

Results

The DB2 UDB for z/OS database for process choreographer exists.



Searchable topic ID:   t2codbzos
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/workflow/tasks/t2codbzos.html

Library | Support | Terms of Use | Feedback