Filter
Top Products
Test Cases for DB2 Table Space Data Sets 181
Figure 112. Test Case 5 - ISMF Storage Group Volume Display
Figure 113 on page 181 shows an extract from an IDCAMS LISTCAT display of
one of the Table space partitions defined in this test, showing the SMS attributes,
and the space allocation in cylinders:
Figure 113. Test Case 5 - IDCAMS LISTCAT Display Extract
A.7 Partitioned Table Spaces Using SMS, User Distribution
Test case 6 illustrates how it is possible to define partitioned table spaces,
ensuring SMS maps each separate partition to a separate Storage Group.
The aim, as in the previous test case, is to obtain the benefits of DB2 parallelism,
but using the naming convention of the Table spaces to assign partitions to each
Storage Group. This example defines two partitioned table spaces, each with four
partitions using an existing naming conventions.
A.7.1 Create Storage Groups
Eight Storage Groups are allocated for the purpose of this test. One disk volume
is assigned to each Storage Group (SGDBA001 - 4 and SGDBB001 - 4). Table 31
VOLUME LIST
Command ===> Scroll ===> HALF
Entries 1-8 of 8
Enter Line Operators below: Data Columns 3-8 of 40
LINE VOLUME FREE % ALLOC FRAG LARGEST FREE
OPERATOR SERIAL SPACE FREE SPACE INDEX EXTENT EXTENTS
---(1)---- -(2)-- --(3)-- (4)- --(5)-- -(6)- --(7)-- --(8)--
RV1CU1 1380300 50 1391200 0 1379525 2
RV1CU2 1380300 50 1391200 0 1379525 2
RV1CU3 1380300 50 1391200 0 1379525 2
RV2CU2 1380300 50 1391200 0 1379525 2
RV2CU3 1380300 50 1391200 0 1379525 2
RV3CU1 1380300 50 1391200 0 1379525 2
RV3CU2 1380300 50 1391200 0 1379525 2
RV3CU3 1380300 50 1391200 0 1379525 2
---------- ------ ----------- BOTTOM OF DATA ----------- ------ ----
CLUSTER ------- DB2D.DSNDBC.BPAOLOR1.PART1.I0001.A001
IN-CAT --- UCAT.VSBOX09
HISTORY
DATASET-OWNER------HAIMO CREATION--------1999.048
SMSDATA
STORAGECLASS ---SCDBTEST MANAGEMENTCLASS--MCDB21
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
ALLOCATION
SPACE-TYPE------CYLINDER HI-A-RBA------1229045760
SPACE-PRI-----------1667 HI-U-RBA---------1474560
SPACE-SEC-----------1667
VOLUME
VOLSER------------RV1CU3