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


Creating the DB2 database for i5/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 DB2iSeries database.

About this task

Before you can run scripts to create a DB2iSeries database manually, you need to customize them for WebSphere ESB. WebSphere ESB comes with following scripts:
Table 1. DB2 for i5/OS scripts for WebSphere ESB
createDatabase_CommonDB.sql
createTable_AppScheduler.sql
createTable_mediation.sql
createTable_RelationshipMetadataTable.sql
createTable_customization.sql
dropTable_AppScheduler.sql
configCommonDB
createTable_CommonDB.sql
createTable_lockmanager.sql
createTable_Recovery.sql
createTable_EsbLoggerMediation.sql
insertTable_CommonDB.sql
configCommonDB.bat
createDBTables
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 system <media_root>/dbscripts/CommonDB or <extract_directory>/dbscripts/CommonDB
  3. Locate the configCommonDB file.
    1. Replace the DB_NAME variable with the database name, for example *LOCAL or *SYSBAS.
    2. Replace the DB_USER variable with the DB2® for i5/OS® user name, for example db2admin.
    3. Replace the DB_SCHEMA variable with the DB2 for i5/OS schema name, for example WPRCSDB.
    Important: You need to pass the createDB parameter to the configCommonDB script if you want to create a new local database; otherwise an existing database will be used.

    Also, you need to specify a unique schema name that does not exist on the system already.

  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. Run the configCommonDB script in QShell. This in turn will run the createDBTables script to create the necessary schema and tables for the Common database.
    Important: You need to have *SECOFR authority on the i5/OS system before you can run these scripts.
  6. If there are any errors, or failure is indicated in your database client output, fix the reported errors and try again.

Results

The schema for the Common 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_iseries_scripts.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).