Filter
Top Products
164 Storage Management with DB2 for OS/390
A.3 Partitioned Table Space, User Defined, Without SMS
Test case 2 illustrates how to allocate a DB2 partitioned table space using user
defined data sets, without SMS. The objective and the table space are the same
as for Appendix A, section A.2, “Partitioned Table Space, DB2 Defined, Without
SMS” on page 162.
A.3.1 DEFINE CLUSTER for 16 Partitions
Sixteen DEFINE CLUSTER statements with explicit volume names, as shown in
Figure 85 on page 164, are needed to create the 16 partitions:
Figure 85. Test Case 2 - DEFINE CLUSTER
A.3.2 CREATE STOGROUP
Only one STOGROUP is required for this test case. Figure 86 on page 164 shows
the related CREATE STOGROUP statement.
Figure86. TestCase2-CREATESTOGROUP
A.3.3 CREATE DATABASE
The database required for this test case is identical to that of test case 1 on
Figure 82 on page 162.
A.3.4 CREATE TABLESPACE
Create the table space, using the high level qualifier (VCAT) to reference the
clusters created in Appendix A, section A.3.1, “DEFINE CLUSTER for 16
Partitions” on page 164.
DEFINE CLUSTER -
( NAME(DB2V610Z.DSNDBC.BPAOLOR1.PART2.I0001.A005) -
LINEAR
-
REUSE
-
VOLUMES(RV2CU1) -
RECORDS(180 180) -
SHAREOPTIONS(3 3) ) -
DATA -
CREATE STOGROUP SGRV1CU0
VOLUMES ("RV1CU0","RV1CU1","RV1CU2","RV1CU3",
"RV2CU0","RV2CU1","RV2CU2","RV2CU3",
"RV3CU0","RV3CU1","RV3CU2","RV3CU3")
VCAT DB2V610Z;