ManagingDB2 Databaseswith SMS 57
may not leaveenough volumes with adequate free space; this could cause a
REORG to fail due to lackof space. The following methods address this issue.
Use One SMSStorage Group for Each Partition
A one-volumeS MSStorage Group can be defined for each partition. The ACS
routineassigns to each par titionits corresponding Storage Group. This method is
similar to creating a DB2defined par titionedt ablespace, using one STOGROUP
for each partition. One SMS Storage Group is defined for each DB2 STOGROUP.
The advantageof this method is strict data set placement. The DB2 administrator
will havethe same disk distributionas he has without SMS. The disadvantage of
this method is that many SMS Storage Groups are required,and the ACS
routines become morecomplex and dependent on DB2 table space names. For
an example,see Appendix A, section A.7, “Partitioned Table Spaces Using SMS,
User Distribution” on page 181.
Use One SMS Storage Group for One Partitio ned TableS pace
Another alternative isto have one specific SMS Storage Group for each
partitioned table space. Enough volumes are assigned to the Storage Group for
all the partitions. SMS distributes the partitions on those volumes. Because this
Storage Group is dedicated to the table space,no other data sets are ever
allocated on these volumes,practically reserving the space for this table space.
If specific volumesof the SMS Storage Group are desired, guaranteed space
must be used toassign the partitions to the specific volumes.
For thissituation, we do not recommend guaranteed space unless the space
requirements are relativelysmall and static.
Touse guaranteed space with DB2 defined data sets, multiple DB2 STOGROUPs
are required. Eachof these STOGROUP must refer to a volume of the SMS
Storage Group.To avoid possible allocation or extensionfailures, if guaranteed
space storage class is used, the storage administrators houldr un the
DFSMShsm space management function more frequently on the set of volumes
assigned to the DB2 STOGROUPs.
If SMS manages the allocation, or if user defined tablespaces are used, only one
DB2 STOGROUPis required, defined with (VOLUMES "*"). The example in
Figure 100 on page 172 shows a definition of such a STOGROUP.The example
described in Appendix A,section A.6, “Partitioned Table Space UsingS MS
Distribution”on page 178 shows how to allocate a partitioned table space using
this method.
6.2 User Databases
This section showshow to assign SMS classes to different types of data. For the
purpose of these examples,the data has been divided into the following
environments:
• Online Production Databases
• Batch Production Databases
• Data Warehouse Databases
• Development and Test Databases