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:
- Create and alter tables
- Create and drop indexes and views.
Procedure
- 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
- Copy the sample upgradeDB.sh file to your working directory. For example:
cp /usr/lpp/zWPS/V6R2/zos.config/samples/upgradeDB.sh /u/work
- Assign the appropriate permissions to the copy of the upgradeDB.sh
file:
chmod 755 upgradeDB.sh
- 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
- Save the edited file.
- 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
- 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.
- 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.