This topic applies only to the z/OS platform

Deciding on schema names and SQL IDs for DB2 for z/OS

You must choose unique names for the schema names and SQL IDs in the DB2® tables.

The DB2 tables must have uniquely qualified schema names to coexist with other IBM® Business Process Manager for z/OS® cells in the same DB2 subsystem. You can use the administrative console to set the current schema or SQL ID value. On the administrative console, click Data source > Custom properties to display the definitions that you want to change.

The DB2 table and index names can be prefixed with the uniquely qualified schema names in the Data Definition Language (DDL) definitions. Alternatively, you can insert a SET CURRENT SCHEMA statement in front of the DDL used to create the tables; for example:

SET CURRENT SCHEMA = 'B6CELL';

Each service integration bus (SIB) database requires unique schema names for its tables, because the same table names are used for all buses. These same schema names must also be set in the SIB Messaging Engine Data Store properties. For more information, see Messaging engines in the WebSphere® Application Server for z/OS information center.