Filter
Top Products
178 Storage Management with DB2 for OS/390
Figure 107. Test Case 4 - IDCAMS LISTCAT Extract
A.6 Partitioned Table Space Using SMS Distribution
Test case 5 illustrates how it is possible to define a partitioned table space,
allowing SMS to control the allocation of each separate partition.
The aim is to distribute the different data sets across multiple disk volumes and
access paths, in order to obtain the benefits of DB2 parallelism. This example
defines a partitioned table space with eight partitions, using an existing naming
convention.
CLUSTER ---------- DB2P.DSNDBC.BRANCH.C0BRCH01.I0001.A001
IN-CAT --- UCAT.VSBOX09
HISTORY
SMSDATA
STORAGECLASS ---SCDBCRIT MANAGEMENTCLASS---MCDB20
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
VOLUME
VOLSER------------RV3CU3
CLUSTER ------- DB2P.DSNDBC.BTRANS.M1CHECK.I0001.A001
IN-CAT --- UCAT.VSBOX09
HISTORY
SMSDATA
STORAGECLASS ----SCDBMED MANAGEMENTCLASS---MCDB21
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
VOLUME
VOLSER------------RV3CU1
CLUSTER ------- DB2P.DSNDBC.CUSTOMER.F0CUST01.I0001.A001
IN-CAT --- UCAT.VSBOX09
HISTORY
SMSDATA
STORAGECLASS ---SCDBFAST MANAGEMENTCLASS---MCDB20
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
VOLUME
VOLSER------------RV1CU0
CLUSTER ------- DB2D.DSNDBC.TESTRANS.T2SUPPLY.I0001.A001
IN-CAT --- UCAT.VSBOX09
HISTORY
SMSDATA
STORAGECLASS ---SCDBTEST MANAGEMENTCLASS---MCDB22
DATACLASS --------(NULL) LBACKUP ---0000.000.0000
VOLUME
VOLSER------------RV1CU2