Filter
Top Products
Test Cases for DB2 Table Space Data Sets 179
A.6.1DefineVolumestoSMSStorageGroup
The SMS Storage Group SGDBTEST, was expanded to contain eight disk
volumes. Figure 108 on page 179 shows the ISMF panel, option 6.1 using the
LISTVOL line command, to display the assigned volumes.
Table 30. Test Case 5 - Storage Group Volumes
Figure 108. Test Case 5 - ISMF Volume List Display
A.6.2 ACS Routines
The Storage, Management Class, and Storage Group routines from test case 3
were used for this test case.
A.6.3 DB2 Definitions
The same CREATE STOGROUP SQL statement used in test case 3 was used
here to allow SMS to control the table space allocation by specifying the
parameter VOLUMES("*"), this is Figure 100 on page 172.
The CREATE DATABASE statement is shown in Figure 109 on page 179.
Figure 109. Test Case 5 - CREATE DATABASE
The CREATE TABLESPACE statement in Figure 110 on page 180, is an extract of
the SQL code used.
SMS STORAGE GROUP VOLUMES
SGDBTEST RV1CU1
RV1CU2
RV1CU3
RV2CU2
RV2CU3
RV3CU1
RV3CU2
RV3CU3
VOLUME LIST
Command ===> Scroll ===>HALF
Entries 1-8 of 8
Enter Line Operators below: Data Columns 3-8
LINE VOLUME FREE % ALLOC FRAG LARGEST FREE
OPERATOR SERIAL SPACE FREE SPACE INDEX EXTENT EXTENTS
---(1)---- -(2)-- --(3)-- (4)- --(5)-- -(6)- --(7)-- --(8)--
RV1CU1 2764251 99 7249 0 2763200 1
RV1CU2 2764251 99 7249 0 2763200 1
RV1CU3 2764251 99 7249 0 2763200 1
RV2CU2 2764251 99 7249 0 2763200 1
RV2CU3 2764251 99 7249 0 2763200 1
RV3CU1 2764251 99 7249 0 2763200 1
RV3CU2 2764251 99 7249 0 2763200 1
RV3CU3 2764251 99 7249 0 2763200 1
---------- ------ ----------- BOTTOM OF DATA ----------- -----
CREATE DATABASE BPAOLOR1
STOGROUP SGRV1CU0
BUFFERPOOL BP0
CCSID EBCDIC