Filter
Top Products
162 Storage Management with DB2 for OS/390
A.2 Partitioned Table Space, DB2 Defined, Without SMS
Test case 1 illustrates how to allocate a DB2 partitioned table space using DB2
defined data sets, without SMS.
The purpose is to distribute the different data sets across multiple volumes and
access paths, in order to obtain maximum benefit from DB2 parallelism. This
example allocates a partitioned table space with 16 partitions on eight volumes.
Two partitions are placed on each volume.
A.2.1CreateEightSTOGROUPs
Figure 81 on page 162 shows an example of the CREATE STOGROUP
statement. Eight similar statements are required to create all eight Storage
Groups:
• SGRV1CU0
• SGRV1CU1
• SGRV1CU2
• SGRV2CU0
• SGRV2CU1
• SGRV3CU0
• SGRV3CU1
• SGRV3CU2
Figure81. TestCase1-CREATESTOGROUP
A.2.2 Create the Database
The CREATE DATABASE statement is shown in Figure 82 on page 162. Any
STOGROUP can be specified here, because it is overridden in the CREATE
TABLESPACE statement.
Figure 82. Test Case 1 - CREATE DATABASE
CREATE STOGROUP SGRV1CU0
VOLUMES ("RV1CU0")
VCAT DB2V610Z;
CREATE DATABASE BPAOLOR1
STOGROUP SGRV1CU0
BUFFERPOOL BP0
CCSID EBCDIC