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 a naming convention for databases on z/OS

You might have multiple IBM BPM for z/OS servers configured in the same cell or different cells, and these servers might use the same DB2 subsystem or same data-sharing group. In this situation, you must plan for a naming convention to isolate the DB2 components.

It is useful to have a naming convention for the following DB2 components:

• Database names
• Storage group names
• Schema qualifiers for your tables
• VSAM catalog names (VCATs), which are the high-level qualifiers used to prefix DB2 table spaces and tables for a DB2 subsystem
• Volumes or SMS storage groups for these data sets

The following example illustrates a naming convention for one database in which the cell name is S5CELL:

Database         Dbase     Storage    Schema   VCAT
                 Name      Group      -Owner   DSN-hlq
-----            --------  --------   -------   ------ 
Common DB:       S5CELLDB  S5DBSTO   S5CELL    DSNV10PP
BPC:             S5CELLDB  S5DBSTO   S5CELL    DSNV10PP
PROCSVR:         S5CELLDB  S5DBSTO   S5S1PS    DSNV10PP
PERFDW:          S5CELLDB  S5DBSTO   S5S1DW    DSNV10PP
APP SIB:         S5CELLDB  S5DBSTO   S5S1A     DSNV10PP
BPC SIB:         S5CELLDB  S5DBSTO   S5S1B     DSNV10PP
CEI SIB:         S5CELLDB  S5DBSTO   S5S1C     DSNV10PP
SCA SIB:         S5CELLDB  S5DBSTO   S5S1S     DSNV10PP
BPMPS SIB:       S5CELLDB  S5DBSTO   S5S1P     DSNV10PP
BPMDW SIB:       S5CELLDB  S5DBSTO   S5S1D     DSNV10PP
CEI:             S5CELLDB  S5DBSTO   S5CELL    DSNV10PP
BSPACE:          S5CELLDB  S5DBSTO   S5CELL    DSNV10PP

The following example illustrates a naming convention for 12 databases in which the WebSphere Application Server cell name is B6CELL:

Database          Dbase     Storage    Schema    VCAT
                  Name      Group      -Owner    DSN-hlq
-----             --------  --------   -------   ------- 
Common DB:        B6BPMDB   B6BPMSTO   B6CELL    B6BPM
BPC:              B6BPEDB   B6BPESTO   B6CELL    B6BPM
PROCSVR:          B6BPSDB   B6BPSSTO   B6BPS     B6BPM
PERFDW:           B6BDWDB   B6BDWSTO   B6BDW     B6BPM
SIBs:             B6SIBAPP  B6SIBSTO   B6CELLA   B6BPM
                  B6SIBSCA  B6SIBSTO   B6CELLS   B6BPM
                  B6SIBBPC  B6SIBSTO   B6CELLB   B6BPM
                  B6SIBCEI  B6SIBSTO   B6CELLC   B6BPM
                  B6SIBBPS  B6SIBSTO   B6CELLP   B6BPM
                  B6SIBBDW  B6SIBSTO   B6CELLD   B6BPM
CEI:              B6EVTDB   B6EVTSTO   B6CELL    B6BPM
BSPACE:           B6BSPACE  B6BSPSTO   B6CELL    B6BPM

: Designing the DB2 for z/OS database objects