DB2Storage Objects 23
3.8.1 TableSpace and Index Space Names
The names for DB2 table spaces and index spaces havethe following structure:
Table3. TableSpace and Index Space Names
The elements of this name are:
hlq VSAM catalog high levelquali fier
DSNDB Standard part of the name
xIdentifies a VSAM cluster or data component
CCluster
DData
dbname Database name
spname Space name. Eithera table space name or an index name. Because
index names can be more than 8 characters long, DB2 sometimes
needs to generatean 8 c haractername. To avoid randomly generated
names, andt o be ableto correlate the index name to the index space,
it is recommended to limit indexnames to 8 characters. This is also
true for tablenames for implicitly defined table spaces (that is, the
creation of thetable is done without having created the table space),
since DB2 willassign a unique table space name.
yData set type:
IStandard data set
SShadow data set
TTemporarydata set
nnnn number = 0001
AStandard character,A
mmm Used for tablespaces or index spaces with multiple data sets; mmm is
either 001, the data set number,or the par tition number.
3.8.2 BSDS Names
The defaultnam es forBSDSs have the following structure:
Table4. BSDSName s
hlq VSAM catalog high level qualifier
BSDS0 Standard part of the name
nBSDS copy,1 or 2
3.8.3 Active Log Names
The defaultnames for active log data sets have the followingstructure:
Table5. ActiveLog Data Set N ames
hlq VSAM catalog high level qualifier
hlq.DSNDBx.dbname.spname.ynnnn.Ammmhlq.BSDS0nhlq.LOGCOPYn.DSmm