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


Creating the common database for the migrated stand-alone server

Run commonDBMigrate602.sh to create the common database for the migrated stand-alone server.

Before you begin

Before running commonDBMigrate602.sh , make sure that you have successfully migrated the server.

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 migrated stand-alone server.

The database tables for Relationship services and Recovery are created when you run commonDBMigrate602.sh .

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 default Set default as profileType if profile is stand-alone
    WAS_HOME C:\ESB62 Directory into which you installed WebSphere ESB.
    profileName ESB01 Version 6.2 Profile name created during migration process
    cellName miracleNode01Cell Cell name of the profile
    nodeName miracleNode01 Node name of the profile
    templatePath %WAS_HOME%\profileTemplates\ default.esbserver Template path used for the profile.
    scope.level node Set node as scope if profile is stand-alone
    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 server.
    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 to be created/used
    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\ESB01 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_sa.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).