WebSphere Enterprise Service Bus for z/OS, Version 6.2.0 Operating Systems: z/OS


Creating the common database for the deployment manager

Run commonDBMigrate602.sh to create the common database for the deployment manager in the migrated network deployment environment.

Before you begin

Before running commonDBMigrate602.sh , make sure you have migrated the Deployment manager.

About this task

The procedure described in this task applies only if you are migrating from version version 6.0.2 to version 6.2.x.

This task topic describes the procedure for running commonDBMigrate602.sh to create the common database for a deployment manager profile in a migrated network deployment environment.

Procedure
  1. Locate commonDBMigrate602.sh

    The file commonDBMigrate602.sh is located in the install_dir/util directory.

  2. Update the parameters in commonDBMigrate602.sh based on the configuration required.

    In order to create common database, tables, indices, WebSphere variables, WebSphere JDBC Driver, WebSphere Data Source and other WebSphere resources you should update the parameters in the script based on the configuration required. Make sure the parameters are correct before you run commonDBMigrate602.batcommonDBMigrate602.sh

    Each database requires specific parameters which either can be passed (some are required) or set to default internally when ant scripts get called from the script.

    The following table lists the names of the parameters and provides sample values for a DB2 database. The values you enter will vary depending on your site's naming conventions and configuration.
    Table 1. Parameter values to set in commonDBMigrate602.sh
    Parameter Value Remarks
    profile.type dmgr Set dmgr as profileType if profile is a Deployment manager profile.
    WAS_HOME C:/ESB62 Directory into which you installed WebSphere ESB.
    profileName Dmgr01 The Profile name created during Deployment manager migration process
    cellName miracleNode01Cell Cell name of the profile
    nodeName miracleNode01 Node name of the profile
    templatePath %WAS_HOME%/ profileTemplates/dmgr.esbserver Template path used for the profile.
    scope.level cell Set cell as scope if profile is dmgr
    dbCreateNew false Existing database used. Set to true if new database is to be created.
    dbDelayConfig false Set this parameter to true if you want to delay running the SQL script.

    For WebSphere® ESB for z/OS® you must set this parameter to true.

    Note: If you set the value for dbDelayConfig to true, then you need to run the generated SQL files manually after running commonDBMigrate602.sh . The generated SQL files are located in the <profile>/dbscripts/CommonDB directory. Make sure you run the SQL files before you start the Deployment Manager
    dbHostName miracle.usca.ibm.com DB2 Universal hostname
    dbJDBCClasspath %WAS_HOME%/ universalDriver_wbi/lib JDBC driver location for the database type you selected.
    dbName WPRCSDB Database name on DB2_UNIVERSAL
    dbType DB2_UNIVERSAL Database Key for DB2_UNIVERSAL
    dbPassword db2admin User on DB2_UNIVERSAL
    dbUserId db2admin Password for User on DB2_UNIVERSAL
    dbServerPort 50000 Server Port used for DB2_UNIVERSAL
  3. Run commonDBMigrate602.sh .
  4. Verify generated logs configDatabase.ant.log, configRecovery.ant.log and configRelationship.ant.log located at %WAS_HOME%/logs/manageprofiles/Dmgr01 for any exceptions.

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.zseries.doc/doc/tmig_wesb_create_com_db_nd.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).