SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD)

Appendix A. Database layout 147

R/3 Releases 3.0F, 3.1H, 3.1I, and 4.0B

The following applies to these releases:

򐂰 Multi-table tablespaces

Several databases are defined for each SAP data class (APPL0, APPL1, and

so on). The name of a database consists of the storage ID that derives from

the data class (APPL0 –> STAB, SLOAD –> LOAD) followed by a two-digit

number (for example, STAB01).

Each database is associated with one or two tablespaces. The name of the

tablespace is the prefix “B” (=32 k page) or “S” (=4 k page) followed by the

database name. For example, tablespaces BSTAB01 and SSTAB01 are

defined for database STAB01.

In addition, two stogroups are defined for each database. Their names are “D”

(=data) for tablespaces and “I” (=index) for indexes, followed by the database

name (for example, ISTAB01 and DSTAB01 for database STAB01).

More than 98% of all tables are created in multi-table tablespaces. They

contain a maximum of 100 tables.

򐂰 Single-table tablespaces

Only large tables (SAP size category 3 or higher) have a tablespace, a

database, and two stogroups of their own. The names of the database and

tablespace consist of the first seven characters of the table name. For the two

stogroup names a prefix of “D” or “I” is added, respectively.

򐂰 Stogroups

The number of active stogroups is twice the number of databases.

SLOAD DLOAD<NN> LOAD<NN> <SID>LOD LO<SB>X<ABC>

SPROT DPROT<NN> PROT<NN> <SID>PRD PR<SB>X<ABC>

SSDEF DES40B<NN> ES40B<NN> <SID>ESD SD<SB>X<ABC>

SSEXC DES40B<NN> ES40B<NN> <SID>ESD SX<SB>X<ABC>

SSRC DSOURC<NN> SOURC<NN> <SID>SOD SO<SB>X<ABC>

TEMP DPROT<NN> PROT<NN> <SID>PRD TM<SB>X<ABC>

USER DUSER1<NN> USER1<NN> <SID>U1D U0<SB>X<ABC>

USER1 DUSER1<NN> USER1<NN> <SID>U1D U1<SB>X<ABC>

3.0F, 3.1H, 3.1I, 4.0B 4.6C/D, 6.10, 6.20