WAS v8.5 > Migrate, coexist, and interoperate > Migrating Service integrationMigrating a messaging engine based on a data store
Depending on your existing settings, when migrating a messaging engine from older versions of WebSphere Application Server to v7.0 or later, you 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 your messaging engine database schemas. DDL for the creation of this table can be generated using the sibDDLGenerator tool located in the bin directory of your WAS installation.
When migrating a messaging engine from the previous version of WAS to v8.5, you might have toalter the existing database tables. Use sibDBUpgrade command to generate the DDLs required to alter the tables.
- 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 v8.5 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.
Related
Generate the DDL statements needed to create or alter data store tables
Reference:
Data store tables
sibDBUpgrade command
Altered database tables