Migrating 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 Version 7.0 or later, you might have to create or alter database tables.

About this task

When migrating from older versions of WebSphere Application Server to Version 7.0 or later, if you 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 by using the sibDDLGenerator tool located in the bin directory of your WebSphere Application Server installation.

When migrating a messaging engine from the previous version of WebSphere Application Server to Version 9.0, you might have to alter the existing database tables. Use sibDBUpgrade command to generate the DDLs that are required to alter the tables.

Procedure

  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 your database administrator to process the DDL statements manually.
    Note: Alternatively, the option to automatically alter the existing tables for Version 9.0 is also available. Although the existing tables that are 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.