sibDBUpgrade command
A messaging engine needs data definition language (DDL) statements to alter the existing database management system (DBMS) resources. The DBMS resources can be altered using the sibDBUpgrade command.
Syntax
The command-line syntax for Unix is:
>>-sibDBUpgrade.sh--+-----------------------------+-------------> '- -runUpgrade--true or false-' >--+------------------------------+-----------------------------> '- -dbUser--database user name-' >--+----------------------------------+-------------------------> '- -dbSchema--database schema name-' >--+-------------------------+--+---------------------------+---> '- -dbType--database type-' '- -serverName--server name-' >--+-------------------------+----------------------------------> '- -dbName--database name-' >--+---------------------------------+--------------------------> '- -dbPassword--database password-' >--+------------------------------+-----------------------------> '- -dbNode--database node name-' >--+--------------------------------+---------------------------> '- -oracleHome--Oracle home path-' >--+-------------------------------+----------------------------> '- -scriptDir--script directory-' >--+-----------------------------------------+------------------> '- -permanent--number of permanent tables-' >--+-----------------------------------------+----------------->< '- -temporary--number of temporary tables-'
The command-line syntax for Windows is:
>>-sibDBUpgrade.bat--+-----------------------------+------------> '- -runUpgrade--true or false-' >--+------------------------------+-----------------------------> '- -dbUser--database user name-' >--+----------------------------------+-------------------------> '- -dbSchema--database schema name-' >--+-------------------------+--+---------------------------+---> '- -dbType--database type-' '- -serverName--server name-' >--+-------------------------+----------------------------------> '- -dbName--database name-' >--+---------------------------------+--------------------------> '- -dbPassword--database password-' >--+------------------------------+-----------------------------> '- -dbNode--database node name-' >--+--------------------------------+---------------------------> '- -oracleHome--Oracle home path-' >--+-------------------------------+----------------------------> '- -scriptDir--script directory-' >--+-----------------------------------------+------------------> '- -permanent--number of permanent tables-' >--+-----------------------------------------+----------------->< '- -temporary--number of temporary tables-'
Purpose
The database administrator can use the sibDBUpgrade utility command to alter the DBMS resources of the messaging engine. The sibDBUpgrade command generates the DDL statements which the database administrator can save and later process to alter the DBMS resources that are listed in the Altered database tables. Besides the database administrator, users who have the authority to alter the database tables can also use the utility to alter the database tables.
To access the IBM® i command line, use the STRQSH command to start a Qshell
session.
For more information, see Configuring Qshell to run WebSphere scripts using wsadmin scripting.
Required parameters
- -runUpgrade true or false [for z/OS, Derby, and Informix, the value must be false]
- The command to alter the database resources. Specify the parameter value as true to alter the database resources and false to generate the DDL scripts only.
- -dbUser
- The name of the user ID that is used to interact with the DBMS.
- -dbSchema
- The name of the schema that contains all the objects used by the messaging engine.
- -dbType
- Identifies the type of DBMS. Valid values are:
- DB2
- Oracle
- SqlServer
- Sybase
- Informix
- Derby
Note: DB2 on zos and iseries platforms is supported.
Optional parameters
- -dbName
- The name of the database that is allocated for the messaging engine tables. The-dbName parameter is mandatory if the value for the runUpgrade parameter is specified as true.
- -serverName
- The name of the server that is used to interact with the DBMS. If you do not supply a -serverName parameter, the default value is IBMUSER.
- -dbPassword
- The password for the user ID that is used to interact with the DBMS.
- -dbNode
- The name of the database node. This optional parameter is applicable only for DB2. The system on which the script is running with -runUpgrade option must have only DB2 Client installed.
- -oracleHome
- The path to the Oracle Home directory if the -dbType parameter value is Oracle.
- -scriptDir
- The name of the directory in which the DDL scripts must be generated. If you do not specify a directory, the scripts are generated into <current_directory>/SIBusUpgradeDatabase directory where current_directory is the active directory.
- -permanent
- The number of permanent tables that are created when the service integration messaging engines are created. For more information about the number of tables configured, see Data store [Settings]. There will be one permanent table by default. If the messaging engine is configured to use multiple permanent tables, then specify the number of tables.
- -temporary
- The number of temporary tables that are created when the service integration messaging engines are created. For more information about the number of tables configured, see Data store [Settings]. There will be one temporary table by default. If the messaging engine is configured to use multiple temporary tables, then specify the number of tables.
Examples
To upgrade the database schema of the service integration bus from the previous
version of WebSphere Application Server to Version 9.0.
- sibDBUpgrade.sh -runUpgrade false -dbUser db2inst1 -dbSchema SIBusMESchema -dbType DB2
- sibDBUpgrade.sh -runUpgrade true -dbName SIBus -dbUser db2inst1 -dbSchema SIBusMESchema -dbType DB2
To upgrade the database schema of the service integration bus from the
previous version of WebSphere Application Server toVersion 9.0.
- sibDBUpgrade.bat runUpgrade=false dbUser=db2inst1 dbSchema=SIBusMESchema dbType=DB2
- sibDBUpgrade.bat runUpgrade=true dbName=SIBus dbUser=db2inst1 dbSchema=SIBusMESchema dbType=DB2