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


Upgrading the databases using the upgradeDB.sh script

You can use the upgradeDB.sh script to upgrade the WebSphere® ESB databases: the Common database, and the Business Space database.

Before you begin

Before you run the upgradeDB.sh script, you must complete the following steps:

About this task

Any database that is accessed by a migrated server must have its schema updated before you start the server. In the case of a cluster, any database that is accessed by any of the migrated cluster members must have its schema updated before you start any of the cluster members. You can use the upgradeDB.sh script to upgrade the databases. The userid that runs upgradeDB.sh must be authorized to perform all of the following operations:
Procedure
  1. On the stand-alone server node or the deployment manager node, access the USS command shell and switch to the administrator user ID, or another userid that has write access to the configuration file system. For example:
    su wsadmin 
  2. Copy the sample upgradeDB.sh file to your working directory. For example:
    cp /usr/lpp/zWPS/V6R2/zos.config/samples/upgradeDB.sh /u/work
  3. Assign the appropriate permissions to the copy of the upgradeDB.sh file:
    chmod 755 upgradeDB.sh
  4. Customize the parameters in the copy of the upgradeDB.sh file as required by your system. See the upgradeDB.sh script topic for more information
  5. Save the edited file.
  6. Set the following environment variables: Set your WAS_HOME variable appropriately. For example:
    export WAS_HOME=/WebSphere/V6S01Z1/AppServer 
    If necessary set your LIBPATH and STEPLIB variables in order to access DB2 code, For example:

    export LIBPATH=/ZOS180/usr/lpp/db2910/lib:$PATH

    export STEPLIB=SYS2.DB2.V910.SDSNEXIT:SYS2.DB2.V910.SDSNLOD2:SYS2.DB2.V910.SDSNLOAD:$STEPLIB

  7. Run the customized upgradeDB.sh script using the following syntax:
    upgradeDB.sh -SourceWPS (version number) 
    You can also specify additional parameters. See the topic upgradeDB.sh script for more information.
  8. Check the error.out file for any errors in the tmp directory that is created by the upgradeDB.sh script in your /u/work directory.

Results

The WebSphere ESB databases have been upgraded.

What to do next

Use the migrating topics in the 'Before you begin' section to complete your migration.


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