Filter
Top Products
Test Cases for DB2 Table Space Data Sets 169
A.4.3 Storage Group
Four Storage Groups, SGDBFAST, 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. Test Case 3 - ISMF Pool Storage Group Definition
Next, using the ISMF edit facility, 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 shows the sample code used:
Figure 94. Test Case 3 - Storage Group Routine Extract
Three disk volumes were allocated to Storage Group SGDBTEST, one on each
available RVA. 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 FOR DB2 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