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.
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.
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:$STEPLIBYou 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
.-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-'
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
upgradeDB.sh -SourceWPS 612
/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