Creating messaging engine tables manually

If you did not automatically create the service integration (SI) bus tables for the IBM® Business Monitor messaging engine during stand-alone profile creation, or while using the configuration wizard, you must create the tables manually. You must also create the tables manually if you are using DB2® for z/OS® for the messaging engine data store.

About this task

You can also create a common event infrastructure (CEI) messaging engine table. When the deployment environment is created, the database scripts for CEI are generated. You must run the scripts manually to complete the configuration if you would like to enable the CEI event store (not recommended for production environments).

Use the sibDDLGenerator command to generate scripts for the SI bus tables. For example, you can use the following command to generate SIB DDL scripts for DB2 for z/OS:

sibDDLGenerator -system db2 -version 8.1 -platform zos

The documentation for the sibDDLGenerator command shows the versions of DB2 that are supported. It does not list all the versions of DB2 that are supported by IBM Business Monitor; however, you can specify version 8.1 as shown in the preceding example and the resulting DDL should be compatible with all supported versions.

Because IBM Business Monitor can have a CEI messaging engine as well as the IBM Business Monitor messaging engine, each created with the same table space and table names, ensure that you either use two different databases or two different schema names.