Migrate a messaging engine based on a data store

Depending on the existing settings, when migrating a messaging engine from older versions of WAS to Version 7.0 or later, we might have to create or alter database tables.

When migrating from older versions of WAS to Version 7.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 the messaging engine database schemas. DDL for the creation of this table can be generated using the sibDDLGenerator tool located in the bin directory of the WAS installation.

When migrating a messaging engine from the previous version of WAS to v8.5, we might have to alter the existing database tables. Use sibDBUpgrade command to generate the DDLs required to alter the tables.

  1. 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.

  2. 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 tasks

  • Generating the DDL statements needed to create or alter data store tables

  • Data store tables
  • sibDBUpgrade command
  • Altered database tables