IBM BPM, V8.0.1, All platforms > Install IBM BPM > Plan for IBM BPM > Plan the database configuration > Designing the DB2 for z/OS database objects

Decide 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 BPM 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. See Messaging engines in the WebSphere Application Server for z/OS information center.

: Designing the DB2 for z/OS database objects