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


upgradeDB.sh script

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

Note the following information about the upgradeDB.sh script:
  • The upgradeDB.sh script does not support migration from version 6.0.1.
  • If you are migrating from 6.0.2 or 6.1.0, upgradeDB.sh will not create the Business Space database. You can run the 6.2.0 version of createDB.sh with the options to create the Business Space tables only.
  • The upgradeDB.sh script does not support migration from DB2 version 7. The migration scripts are provided with V6.2.0, but upgradeDB.sh does not run them.

Copy the upgradeDB.sh script to your work directory from the WebSphere ESB path name created by the SMP/E installation. By default the location is /usr/lpp/zWPS/V6R2/zos.config/samples.

Customize the script and run using the syntax and examples below.

Fields to customize

Before you run the upgradeDB.sh script, you must customize certain fields in the script. For example, you must supply the user name and password for the account that is authorized to create and drop the database objects. Setup the following environment variables prior to running WAS_HOME, LIBPATH, and STEPLIB. For example:
export WAS_HOME=/WebSphere/V6S05Z1/AppServer
export LIBPATH=/usr/lpp/db2810/db2810/jcc/lib:$LIBPATH
export STEPLIB=SYS2.DB2.V810.SDSNEXIT:SYS2.DB2.V810.SDSNLOD2:SYS2.DB2.V810.SDSNLOAD:$STEPLIB
You can customize the following parameters:
DBJDBCClasspath=/usr/lpp/db2810/db2810/jcc/classes
DBUser=wsadmin
DBPassword=admn4was
DBJDBCProperties=/wps/dbscripts/db2v8
DBConnectionLocation=DSN810PP
DBHostName=winmvsp1.hursley.ibm.com
DBServerPort=448

Syntax

Read syntax diagramSkip visual syntax diagram
                              .-602-.  .- -DBWPS-.   
>>-upgradeDB.sh-- -SourceWPS--+-610-+--+---------+-------------->
                              '-612-'  '-+DBWPS--'   

                                 .- -DBBPC-.  .- -DBBS-.   
>--+------------+--+----------+--+---------+--+--------+-------->
   '- -DBSchema-'  '- -DBName-'  '-+DBBPC--'  '-+DBBS--'   

   .- -DBAll-.  .- -SQLGen-.  .- -RunSQL-.  .- -UseSqlid-.   
>--+---------+--+----------+--+----------+--+------------+------>
   '-+DBAll -'  '-+SQLGen--'  '-+RunSQL--'  '-+UseSqlid--'   

   .- -DBDelayConfig-.                                 
>--+-----------------+--+----------+--+------------+-----------><
   '-+DBDelayConfig--'  '- -DBName-'  '- -DBStoGrp-'   

Parameters

By default the script upgrades all the WebSphere ESB database tables.
-SourceWPS
The version of WebSphere ESB that you are migrating from, for example 602, 610, 612.
-DBWPS
Do not upgrade the WebSphere ESB common database objects.
+DBWPS
Upgrade the WebSphere ESB common database objects such as tables, table spaces, indices, and index spaces.
-DBBPC
Do not upgrade the Business Process Choreographer database objects.
+DBBPC
Upgrade the Business Process Choreographer database objects.
-DBBS
Do not upgrade the Business Space database objects.
+DBBS
Upgrade the Business Space database objects. This parameter is ignored if -SourceWPS is not set to 612.
-DBAll
Bypass all databases.
+DBAll
Upgrade all databases.
-SQLGen
Run Existing SQL.
+SQLGen
Regenerate SQL.
-RunSQL
Bypass updating database.
+RunSQL
Update database.
-UseSqlid
Do not use SET CURRENT SQLID.
+UseSqlid
Use SET CURRENT SQLID.
-DBDelayConfig
Do not delay config.
+DBDelayConfig
Delay config.
-DBSchema
DataBase schema.
-DBName
DataBase name.
-DBStoGrp
DataBase storage group.

Example

Here is an example of the createDB.sh command to create the Business Space database objects if -SourceWPS is either 602 or 610:

createDB.sh -All +DBBS  
The following command generates and runs the SQL to migrate from WPS 6.1.2:
upgradeDB.sh -SourceWPS 612
The following is an example of sample output:
/u/healdr/dbscripts/db2v8/wpsv620:>./upgradeDB.sh -SourceWPS 612

upgradeDB.sh script executing ... Thu Mar  5 09:32:53 GMT 2009

Values being used:
  Source WPS version = 612
  Upgrade database S5CELLDB = true
  Append CurrentSqlid S5CELL = true
  Database storage group = S5DBSTO
  Generate SQL = true
  Upgrade WPS Database = true
          BPC Database = true
          BusinessSpace Database = true

  DBDelayConfig                false
  DBPrefix                     S5
  DBScope                      S1
  DBJDBCClasspath              /usr/lpp/db2810/db2810/jcc/classes
  DBUser                       wsadmin
  DBPassword                   admn4was
  DBJDBCProperties             /wps/dbscripts/db2v8
  DBConnectionLocation         DSN810PP
  DBHostName                   winmvsp1.hursley.ibm.com
  DBServerPort                 448

Upgrading WPS Definitions
  Processing SQL file upgradeSchema612_CommonDB.sql
  Generating SQL
  Running SQL
      [sql] 10 of 10 SQL statements executed successfully
  Processing SQL file upgradeSchema612_DirectDeploy.sql
  Generating SQL
  Running SQL
      [sql] 17 of 17 SQL statements executed successfully
  Processing SQL file upgradeSchema612_Recovery.sql
  Generating SQL
  Running SQL
      [sql] 4 of 4 SQL statements executed successfully
  Processing SQL file upgradeSchema612_governancerepository.sql
  Generating SQL
  Running SQL
      [sql] 81 of 95 SQL statements executed successfully
  Processing SQL file upgradeSchema612_relationshipService.sql
  Generating SQL
  Running SQL
      [sql] 3 of 3 SQL statements executed successfully

Upgrading BPC Definitions
  Generating SQL
  Running SQL
      [sql] 33 of 33 SQL statements executed successfully
      [sql] 147 of 147 SQL statements executed successfully

Upgrading Business Space Definitions
  Generating SQL
  Running SQL
      [sql] 20 of 23 SQL statements executed successfully
      [sql] 9 of 9 SQL statements executed successfully

Processing Complete 

The following command generates the d SQL to migrate from WPS 6.0.2 and reports what to run, but does not run it:

upgradeDB.sh -SourceWPS 602 -RunSQL

Sample output:

/u/healdr/dbscripts/db2v8/wpsv620:>./upgradeDB.sh -SourceWPS 602 -RunSQL

upgradeDB.sh script executing ... Tue Mar 10 18:23:49 BST 2009

Values being used:
  Source WPS version = 602
  Upgrade database S5CELLDB = false
  Append CurrentSqlid S5CELL = true
  Database storage group = S5DBSTO
  Generate SQL = true
  Upgrade WPS Database = true
          BPC Database = true
          BusinessSpace Database = true

  DBDelayConfig                false
  DBPrefix                     S5
  DBScope                      S1
  DBJDBCClasspath              /usr/lpp/db2810/db2810/jcc/classes
  DBUser                       wsadmin
  DBPassword                   admn4was
  DBJDBCProperties             /wps/dbscripts/db2v8
  DBConnectionLocation         DSN810PP
  DBHostName                   winmvsp1.hursley.ibm.com
  DBServerPort                 448

Upgrading WPS Definitions
  Processing SQL file upgradeSchema602_CommonDB.sql
  Generating SQL
  Processing SQL file upgradeSchema602_DirectDeploy.sql
  Generating SQL
  Processing SQL file upgradeSchema602_Recovery.sql
  Generating SQL
  Processing SQL file upgradeSchema602_customization.sql
  Generating SQL
  Processing SQL file upgradeSchema602_governancerepository.sql
  Generating SQL
  Processing SQL file upgradeSchema602_relationshipService.sql
  Generating SQL

Upgrading BPC Definitions
  Processing SQL file upgradeTablespaces602.sql, upgradeSchema602.sql
  Generating SQL

Processing Complete

To upgrade WebSphere Enterprise Service Bus, the Business Process Choreographer database does not exist and does not need to be upgraded. The following commands upgrade the Common database and (optionally) the Business Space database:

upgradeDB.sh -SourceWPS 610 -All +DBWPS
upgradeDB.sh -SourceWPS 612 -All +DBBS 

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