ManagingDB2 Databaseswith SMS 53
Figure 17. Volumesin Storage G roup SGDB20
6.1.7 Assigning SMS Classes to DB2 Table Spaces and Index Spaces
SMS classes andS torageGroups are assigned to DB2 table spaces and index
spaces through ACS routines.Normally, ACS routines have only the data set
name availablefor their decision making process. Many methods can be devised
withspecific naming standards to assign SMS classes based on the names of the
DB2 data sets. Twotypes of methods are described, the filter method and the
code method.
The filter method must be used whenthe names are established and cannot be
changed. This isthe case when an existing DB2 system converts to SMS
management. The filter method uses lists of names inside the ACS routine to
determine SMS classes.
The code method requires naming conventionsfor DB2 objects that must be
strictly enforced.SMS related codes are inserted into the DB2 object names.
These codes are usedto determine SMS classes. At least two codes are
required, onet odefine the Storage Class, and one to define the Management
Class.
The DB2 data set names have a specifics tructure,shown in Table 3 on page 23.
These names have only three components that are dependent on the user and
can contain meaningful information forthe ACS routine to use. These are:
• High level qualifier
• Database name
• Table space name
The ACSroutines can use the filter method, the code method, or a combinationof
the filter andcode methods, and apply these to the three types of names, or to
Panel Utilities Help
--------------------------------------------------------------------------
STORAGE GROUP VOLUME SELECTION
Command ===>
CDS Name . . . . . : SMS.SCDS1.SCDS
Storage Group Name : SCDB20
Storage Group Type : POOL
Select One of the following Options:
1 1. Display - Display SMS Volume Statuses (Pool only)
2. Define - Add Volumes to Volume Serial Number List
3. Alter - Alter Volume Statuses (Pool only)
4. Delete - Delete Volumes from Volume Serial Number List
Specify a Single Volume (in Prefix),or Range of Volumes:
Prefix From To Suffix Hex
______ ______ ______ _____ _
===> VOL 001 012 ('X' in HEX field allows
===> FROM - TO range to include
===> hex values A through F.)
===>
F1=Help F2=Split F3=End F4=Return F7=Up F8=Down F9=Swap
F10=Left F11=Right F12=Cursor