WebSphere Enterprise Service Bus for z/OS, Version 6.2.0 Operating Systems: z/OS


Deciding on schema names and SQL IDs

It is important that you 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 WebSphere® ESB for z/OS® cells in the same DB2 subsystem. You can set the current schema or SQL ID value using the administrative console. On the administrative console, click Data source > Custom properties to display the definitions you want to change.

The DB2 table and index names can be prefixed with these names in the DDL definitions, or you can insert a SET CURRENT SQLID statement in front of the DDL used to create the tables. For example:
SET CURRENT SQLID = 'B6CELL';

Each of the SIB databases 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.


concept Concept topic

Terms of use | Feedback


Timestamp icon Last updated: 21 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic//com.ibm.websphere.wesb620.zseries.doc/doc/cins_zos_decide_snsq.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).