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

Get SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in One Database (MCOD) now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.