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.
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-'
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.
To upgrade the
database schema of the service integration bus from the previous version
of WebSphere Application Server to Version 8.5.
To upgrade the database schema of the service
integration bus from the previous version of WebSphere Application Server toVersion 8.5.