Migrate a messaging engine based on a data store
Depending on our existing settings, when migrating a messaging engine from older versions of WebSphere Application Server to v7.0 or later, we might have to create or alter database tables.
When migrating from older versions of WAS to v7.0 or later, if we do not have the "create tables automatically" option selected, it will be necessary to create a new table (SIBOWNERO) in each of our messaging engine database schemas. DDL for the creation of this table can be generated using the sibDDLGenerator tool located in the bin directory of our WAS installation.
When migrating a messaging engine from the previous version of WAS to v9.0, we might have to alter the existing database tables. Use sibDBUpgrade command to generate the DDLs required to alter the tables.
Tasks
- Use the sibDDLGenerator tool to generate the DDL for the creation of this table or sibDBUpgrade to generate the DDL to alter the existing tables.
- Send the output file to the database administrator to process the DDL statements manually.
Alternatively, the option to automatically alter the existing tables for v9.0 is also available. Although the existing tables required to be changed will not be automatically altered for DB2 on z/OS, Derby, and Informix databases. The only option to alter the tables for DB2 on z/OS, Derby, and Informix databases is to generate the DDL scripts and execute them manually.
Generate the DDL statements needed to create or alter data store tables Data store tables sibDBUpgrade command Altered database tables