ManagingDB2 Databaseswith SMS 55
Figure 18. ACSRo utine Extract Using Tableand Index Name Filt er List
Table Space Name Codes
The DB2 table space and index space names contain a Storage Class code and
a Management Class code. These codes are used to assign the specific SMS
classes. Each tablespac e and each indexspac e can havedistinct SMS classes.
The ACS routines do not need maintenance for newt ablespaces and index
spaces. This method is recommendedwhen multiple requirements havet o be
satisfied. This method providesthe most detailed granularity for SMS
management and has limitedmaintenance concerns.
The names of DB2 indexes,including the SMS codes, must not exceed 8
characters.DB 2may change the index space name for indexeshaving names in
excess of8 characters. The changed names may invalidatethis method.
An exampleof how to structure DB2 data set names to use this method is shown
in 6.1.8, “TableSpace and Index Space Names for SMS” on page 56.
An implementation example of this method is shown in Appendix A, section A.5,
“DB2 TableSpaces Using SMS, Coded Names” on page 174. In thisappendix,
Figure 105 on page 176 and Figure 106 on page 176 show ACS routines that
assign Storage Classes and Management Classes based on codes within the
table space name.
/*********************************************************************/
/* PARTITION FILTER
/*********************************************************************/
FILTLIST &PTSP INCLUDE ('LINEITEM','ORDER','PART','PARTSUPP',
'SUPPLIER','NATION','REGION')
/* Supply a list of the partitioned tablespaces
*/
FILTLIST &PNDX INCLUDE ('PXL@OK','PXO@OK','PXP@PK','PXPS@SK',
'PXS@SK','PXN@NK','PXR@RK')
/* Supply a list of the partitioned indexes
*/
WHEN ( (&DSN(4) = &PTSP OR &DSN(4)= &PNDX)
AND (&LLQ EQ 'A001' OR &LLQ EQ 'A002'))
SET &STOGROUP EQ 'SGDB2GRA'
WHEN ( (&DSN(4) = &PTSP OR &DSN(4)= &PNDX)
AND (&LLQ EQ 'A003' OR &LLQ EQ 'A004'))
SET &STOGROUP EQ 'SGDB2GRB'
WHEN ( (&DSN(4) = &PTSP OR &DSN(4)= &PNDX)
AND (&LLQ EQ 'A005' OR &LLQ EQ 'A006'))
SET &STOGROUP EQ 'SGDB2GRC'
/* Repeat the previous WHEN statement for as many STOGROUPs as reqd