IBM 5655-DB2 Server User Manual


 
Test Cases for DB2 Recovery Data Sets 193
B.2.3 Storage Group
One Storage Group, SGDBARCH, was added for all archive log data sets of the
three DB2 subsystems. Three disk volumes, RV1CU0, RV2CU0, and RV3CU0,
were defined to the Storage Group as shown in Table 33 on page 193.
Figure 130 on page 193 shows an extract of the extended Storage Group ACS
routine used in the previous test case, now incorporating the archive logs.
Table 33. Archive Logs—Storage Group Volumes
Figure 130. Storage Group Routine Incorporating Archive Logs
B.2.4 Data Set Allocation Results
ISMF Test cases were built and executed against both the updated SCDS and
ACDS, producing the expected results.
After the new SMS configuration was activated, the following MVS command was
issued using SDSF to generate new archive logs:
=DB2P ARCHIVE LOG MODE(QUIESCE)
Figure 131 on page 193 displays an extract of the subsequent MVS SYSLOG
messages issued.
Figure 131. SYSLOG Message Ouput Extract for Archive Logs
SMS STORAGE GROUP VOLUMES
SGDBARCH RV1CU0
RV2CU0
RV3CU0
/************************************************/
/* STORAGE GROUP */
/* SELECTION ROUTINE FOR DB2 RECOVERY DATA SETS */
/************************************************/
SELECT
WHEN ((&STORCLAS = 'SCDBACTL')
AND (&DSN(1) = 'DB2D'))
SET &STORGRP = 'SGDBACTL'
WHEN ((&STORCLAS = 'SCDBACTL')
AND (&DSN(1) = 'DB2T'))
SET &STORGRP = 'SGDBACTL'
WHEN ((&STORCLAS = 'SCDBACTL')
AND (&DSN(1) = 'DB2P'))
SET &STORGRP = 'SGDB2PLG'
WHEN (&STORCLAS = 'SCDBARCH')
SET &STORGRP = 'SGDBARCH'
END
DSNJ003I =DB2P DSNJOFF3 FULL ARCHIVE LOG VOLUME 474
DSNAME=DB2P.ARCHLOG2.D99057.T1202900.A0000001, STARTRBA=000000000000,
ENDRBA=00000068AFFF, STARTTIME=B1B68D1C709B, ENDTIME=B1DDE7C34366,
UNIT=SYSALLDA, COPY2VOL=RV3CU0, VOLSPAN=00, CATLG=YES
DSNJ139I =DB2P LOG OFFLOAD TASK ENDED