upgradeDB.sh 스크립트를 사용하여 WebSphere® ESB 데이터베이스(공통 데이터베이스, Business Process Choreographer 데이터베이스 및 Business Space 데이터베이스)를 업그레이드할 수 있습니다.
SMP/E 설치로 작성된 WebSphere ESB 경로 이름에서 작업 디렉토리로 upgradeDB.sh 스크립트를 복사하십시오. 기본적으로 이 위치는 /usr/lpp/zWPS/V6R2/zos.config/samples입니다.
아래 구문 및 예제를 사용하여 스크립트를 사용자 정의하고 실행하십시오.
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다음 매개변수를 사용자 정의할 수 있습니다.
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-'
다음은 -SourceWPS가 602 또는 610인 경우 Business Space 데이터베이스 오브젝트를 작성하기 위한 createDB.sh 명령의 예제입니다.
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
다음 명령은 사용자 정의된 SQL을 생성하여 WPS 6.0.2에서 이주하고 실행할 사항을 보고하지만 실행하지는 않습니다.
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
WebSphere Enterprise Service Bus를 업그레이드하기 위해, Business Process Choreographer 데이터베이스가 없으며 업그레이드할 필요가 없습니다. 다음 명령은 공통 데이터베이스 및 선택적으로 Business Space 데이터베이스를 업그레이드합니다.
upgradeDB.sh -SourceWPS 610 -All +DBWPS upgradeDB.sh -SourceWPS 612 -All +DBBS