IBM 5655-DB2 Server User Manual


 
172 Storage Management with DB2 for OS/390
Figure 99 on page 172 shows the test case results for the same pattern table
space name against the updated SCDS. This time, with the relevant source code
in place, the SMS qualification is successful, and Management Class and
Storage Group attributes are also assigned:
Figure 99. Test Case 3 - ISMF Test against the Updated SCDS
A.4.5 Updating the Active Configuration
For each update of an ACS routine or construct definition, a procedure of
translating and validating the code must be performed by the storage
administrator prior to activating the new configuration. This is executed using
ISMF, option 7 panels. See
DFSMS/MVS V1R4 DFSMSdfp Storage
Administration Reference,
SC26-4920, for further information on this process.
A.4.6 DB2 Definitions
To allow SMS to control the table space allocation, an appropriate SQL statement
must be coded to reflect this in the definition of a DB2 STOGROUP. Figure 100 on
page 172 shows the parameter,
VOLUMES("*"), used to achieve this for one of
the STOGROUPs.
Figure 100. Test Case 3 - CREATE STOGROUP
Figure 101 on page 173 shows an extract of the CREATE statement used to
define the databases for the purpose of this test:
ACS TESTING RESULTS
CDS NAME : SMS.SCDS1.SCDS
ACS ROUTINE TYPES: DC SC MC SG
ACS TEST LIBRARY : PAOLOR3.JCL.CNTL
ACS TEST
MEMBER EXIT CODE RESULTS
--------- ---------- ------------------------------------
DESCRIPTION: DB2D.DSNDBC.BTRANS.TEST1.I0001.A001
SMSTEST1 0 DC = NULL VALUE ASSIGNED
0 SC = SCDBTEST
0 MC = MCDB21
0 SG = SGDBTEST
ACS TESTING RC: 00
CREATE STOGROUP SGRV1CU0
VOLUMES ("*")
VCAT DB2D;