Filter
Top Products
Test Cases for DB2 Table Space Data Sets 163
A.2.3 Create the Table Space
The CREATE TABLESPACE statement is shown in Figure 83 on page 163. In this
statement, each partition is directed to a specific STOGROUP.
Figure 83. Test Case 1 - CREATE TABLESPACE
A.2.4 Display a Volume
Volumes can be displayed, to ensure that the allocation was done correctly. As an
example, Figure 84 on page 163 shows the contents of volume RV1CU0. From
this figure we can see that only two data sets are allocated on this volume. This is
the expected result:
Figure 84. Test Case 1 - Display of Volume RV1CU0
CREATE TABLESPACE PART1
IN BPAOLOR1
USING STOGROUP SGRV1CU0
PRIQTY 20
SECQTY 20
ERASE NO
NUMPARTS 16
(PART 1 USING STOGROUP SGRV1CU0
PRIQTY 720
SECQTY 720,
PART 2 USING STOGROUP SGRV1CU1
PRIQTY 720
SECQTY 720,
.... ..... ...
PART 16 USING STOGROUP SGRV3CU2
PRIQTY 720
SECQTY 720)
LOCKSIZE ANY LOCKMAX SYSTEM
BUFFERPOOL BP0
CLOSE NO
COMPRESS YES
CCSID EBCDIC
Menu Options View Utilities Compilers Help
-------------------------------------------------------------------------------
DSLIST - Data Sets on volume RV1CU0 Row 1 of 4
Command ===> Scroll ===> CSR
Command - Enter "/" to select action Message Volume
-------------------------------------------------------------------------------
DB2V610Z.DSNDBD.BPAOLOR1.PART1.I0001.A001 RV1CU0
DB2V610Z.DSNDBD.BPAOLOR1.PART1.I0001.A009 RV1CU0
SYS1.VTOCIX.RV1CU0 RV1CU0
SYS1.VVDS.VRV1CU0 RV1CU0
***************************** End of Data Set list ****************************