TestCases for DB2 TableS pace Data Sets 169
A.4.3 S torageGroup
Four StorageG roups,S GDBFAST,SGDB20,SGDBCRIT, and SGDBTEST were
defined using ISMF,option 6.2. Figure 93 on page 169 shows the associated
panel used by the storage administrator for the definition of POOL Storage
Groups:
Figure 93. TestCase 3 - IS MF PoolS torage Group Definition
Next, using the ISMF editfacility, the code was added to the ACS source to allow
the selection of the newly defined Storage Groups, based upon the Storage Class
variable &STORCLAS.Figure 94 on page 169 s howst he sample code used:
Figure 94. TestCase 3 - S torage Group Routine Extract
Three disk volumes were allocated to Storage Group SGDBTEST,one on each
availableRVA. Likewise, two volumes were assigned to each of the other Storage
Groups,SGDBFAST, SGDBCRIT and SGDB20. Figure 95 on page 170 shows an
POOL STORAGE GROUP DEFINE
Command ===>
SCDS Name . . . . . : SMS.SCDS1.SCDS
Storage Group Name : SGDBTEST
To DEFINE Storage Group, Specify:
Description ==> STORAGE GROUP FORDB2 TEST TABLE SPACES
==>
Auto Migrate . . Y (Y, N, I or P) Migrate Sys/Sys Group Name . .
Auto Backup . . n (Y or N) Backup Sys/Sys Group Name . .
Auto Dump . . . n (Y or N) Dump Sys/Sys Group Name . . .
Dump Class . . . (1 to 8 characters)
Dump Class . . . Dump Class . . .
Dump Class . . . Dump Class . . .
Allocation/migration Threshold: High . . 60 (1-99) Low . . 25 (0-99)
Guaranteed Backup Frequency . . . . . . (1 to 9999 or NOLIMIT)
DEFINE SMS Storage Group Status . . .... N (Y or N)
/************************************/
/* STORAGE GROUP SELECTION ROUTINE */
/************************************/
SELECT
WHEN (&STORCLAS = 'SCDBTEST')
SET &STORGRP = 'SGDBTEST'
WHEN (&STORCLAS = 'SCDBFAST')
SET &STORGRP = 'SGDBFAST'
WHEN (&STORCLAS = ’SCDBCRIT’)
SET &STORGRP = ’SGDBCRIT’
WHEN (&STORCLAS = 'SCDBMED')
SET &STORGRP = 'SGDB20'
END