IBM 5655-DB2 Server User Manual


 
66 Storage Management with DB2 for OS/390
SGDBACTL Storage Group intended for BSDSs and active logs for all
non-production DB2 subsystems. Because the corresponding
Storage Class has guaranteed space defined as yes,theDB2
administrator can direct the allocation of the data sets on volumes
which are dedicated to a specific DB2 subsystem.
SGDB2PLG Storage Group intended for BSDSs and active logs for the
production DB2P subsystem. The Storage Class contains the
volumes for the DB2P subsystem. The DB2 administrator can
direct the allocation of the data sets on specific volumes of this
Storage Group. Because guaranteed space is used for the
SGDBACTL and SGDB2PLG Storage Groups, it is not strictly
necessary to create a separate SMS Storage Group for each DB2
subsystem, it simply is one of the many choices available to the
DB2 administrator.
Table 21. Relating SMS Storage and Management Classes to Storage Groups
Table 22. SMS Storage Groups for DB2 Recovery Data Sets
7.1.5 Assigning SMS Classes to DB2 Recovery Data Sets
SMS classes and Storage Groups are assigned through ACS routines. The
naming standard from 3.8, “DB2 Data Sets Naming Conventions” on page 22 is
used for these examples. This naming standard provides ACS routines with the
necessary information for deciding the SMS classes.
Storage Classes
Management Classes
MCDBICD MCDBICW MCDBICM MCDBLV2 MCDBACTL
SCDBIC SGDBIC SGDBIC SGDBIC SGDBARCH
SCDBICH SGDBICH SGDBICH SGDBICH SGDBARCH
SCDBARCH SGDBARCH SGDBARCH
SCDBACTL SGDBACTL
SGDB2PLG
Storage Group Auto-Migrate Auto-Backup Auto-Dump High-Low Thr
SGDBIC Yes No No 70-5 0
SGDBICH Yes No No 70-5 0
SGDBARCH Yes No No 60-4 0
SGDBACTL No No No 99-0
SGDB2PLG No No No 99-0