Filter
Top Products
Managing DB2 Databases with SMS 51
SGDBTEST Storage Group for DB2 table spaces and index spaces with low
performance and availability requirements. This Storage Group
allows migration.
SGDBXXXX Other Storage Groups intended for specific partitioned DB2 table
spaces and index spaces, or for other critical table spaces, where
strict placement is considered essential. XXXX is any four
characters.
The attributes of these Storage Groups are similar to one of the other Storage
Groups. These Storage Groups are intended to give DB2 administrators the
possibility of placing individual partitions on specific volumes.
Table 14. Relating SMS Storage and Management Classes to Storage Groups
The Storage Groups are defined with specific attributes. Table 15 on page 51
shows attributes for the example Storage Groups.
Table 15. SMS Storage Groups for DB2 Databases
Figure 16 on page 52 is an ISMF display of the Storage Group SGDB20. A
Storage Group requires volumes for data set allocation. Figure 17 on page 53
shows the volumes in Storage Group SGDB20. Twelve volumes are assiged to
SGDB20. The names of these volumes range from VOL001 to VOL012.
Storage Classes
Management Classes
MCDB20 MCDB21 MCDB22
SCDBMED SGDB20
SGDBXXXX
SGDB21 SGDB22
SCDBFAST SGDBFAST
SGDBXXXX
SCDBCRIT SGDBCRIT
SGDBXXXX
SCDBTEST SGDBTEST SGDBTEST SGDBTEST
Storage Group Auto-Migrate Auto-Backup Auto-Dump High-Low Thr
SGDB20 No No No 70-70
SGDB21YesNoNo70-50
SGDB22YesNoNo60-25
SGDBFAST No No No 70-70
SGDBCRIT No No No 60-60
SGDBTEST Yes No No 60-25
SGDBXXXX No No No 99-00