TestCases for DB2 TableS pace Data Sets 183
Figure 115. TestCase 6 - Storage Group ACS Routine Extract
A.7.3 DB2 Definitions
TwoSTOGROUPs were created in DB2P,(SGDBA000 and SGDBB000). Both
STOGROUPshave VOLUMES("*"), as in example of Figure 100 on page 172.
DATABASE BPAOLOR1is created using STOGROUP SGDBA000.
TwoTABLESPACEsare created. Figure 116 on page 184 shows an extract of the
SQL statements used for this purposes.
A.7.4 Data Set Allocation Results
A number of test cases were builtusing ISMF, option 7.4, prior to updating the
active configuration to prove the validity of the ACS routines. All produced
successful results.
The two partitioned data sets were then allocated. Figure 117 on page 184 is a
view of all data sets with a pattern name of 'DB2P.DSNDBD.BPAOLOR1.**',
usingan extract of ISMFopt ion 2.The output shows each par tition on a separate
disk volume. This is the desired objective.
/*******************************************/
/* STORAGE GROUP SELECTION ROUTINE */
/*******************************************/
SELECT
WHEN ((&DSN(4) = 'ALPHA')
AND (&LLQ EQ 'A001'))
SET &STORGRP = 'SGDBA001'
WHEN ((&DSN(4) = 'ALPHA')
AND (&LLQ EQ 'A002'))
SET &STORGRP = 'SGDBA002'
WHEN ((&DSN(4) = 'ALPHA')
AND (&LLQ EQ 'A003'))
SET &STORGRP = 'SGDBA003'
WHEN ((&DSN(4) = 'ALPHA')
AND (&LLQ EQ 'A004'))
SET &STORGRP = 'SGDBA004'
WHEN ((&DSN(4) = 'BETA')
AND (&LLQ EQ 'A001'))
SET &STORGRP = 'SGDBB001'
WHEN ((&DSN(4) = 'BETA')
AND (&LLQ EQ 'A002'))
SET &STORGRP = 'SGDBB002'
WHEN ((&DSN(4) = 'BETA')
AND (&LLQ EQ 'A003'))
SET &STORGRP = 'SGDBB003'
WHEN ((&DSN(4) = 'BETA')
AND (&LLQ EQ 'A004'))
SET &STORGRP = 'SGDBB004'
END