Filter
Top Products
Test Cases for DB2 Table Space Data Sets 183
Figure 115. Test Case 6 - Storage Group ACS Routine Extract
A.7.3 DB2 Definitions
Two STOGROUPs were created in DB2P, (SGDBA000 and SGDBB000). Both
STOGROUPs have VOLUMES("*"), as in example of Figure 100 on page 172.
DATABASE BPAOLOR1 is created using STOGROUP SGDBA000.
Two TABLESPACEs are 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 built using 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.**',
using an extract of ISMF option 2. The output shows each partition 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