WebSphere Enterprise Service Bus, Version 6.2.0 Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows


Creating the DB2 database for z/OS

In order to create a Common database manually, you need to edit and run the scripts that come with WebSphere® ESB. This topic tells you how to edit and run scripts associated with the DB2® for z/OS® database.

About this task

Before you can run scripts to create a DB2 for z/OS database manually, you need to customize them for WebSphere ESB. WebSphere ESB comes with following scripts:
Table 1. DB2 for z/OS scripts for WebSphere ESB
createTable_CommonDB.sql
createTable_EsbLoggerMediation.sql
createTable_Recovery.sql
createTable_RelationshipService.sql
createTable_governancerepository.sql
insertTable_CommonDB.sql
Procedure
  1. Make sure that you are using a user ID with sufficient authority to update the database schema.
  2. Locate the directory where the database scripts are located:
    • For i5/OS operating systemFor Linux operating systemFor UNIX operating system <media_root>/dbscripts/CommonDB or <extract_directory>/dbscripts/CommonDB
    • For Windows operating system <media_root>\dbscripts\CommonDB or <extract_directory>\dbscripts\CommonDB
  3. Choose whether to edit the scripts in directory DB2zOSV8 or DB2zOSV9.
  4. Locate the insertTable_CommonDB.sql file and replace the following variables with the WebSphere ESB version you are installing. For example, if the WebSphere ESB version is 6.2.0.0 then:
    1. Replace the MajorVersion variable with the first digit of the product version number, for example 6.
    2. Replace the MinorVersion variable with the second digit of the product version number, for example 2.
    3. Replace the RefreshPackLevel variable with the third digit of the product version number, for example 0.
    4. Replace the FixpackLevel variable with the fourth digit of the product version number, for example 0.
  5. Replace the following variables in the DB2 for z/OS scripts with your database-specific information: V_DBNAME, V_DBSTORAGEGROUP, V_SQLID, DBNAME, and STOGRP.
  6. Run the DB2 for z/OS scripts, which are listed in Table 1. For information on how to run a .sql script with your database, refer to the documentation for your database product.
  7. If there are any errors, or failure is indicated in your database client output, fix the reported errors and try again.

Results

The DB2 for z/OS database is created.

task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.doc/doc/tins_edit_db2_zseries_scripts.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).