Filter
Top Products
Test Cases for DB2 Table Space Data Sets 173
Figure 101. Test Case 3 - CREATE DATABASE Extract
Figure 102 on page 173 shows an extract of the CREATE TABLESPACE
statements used for the purposes of this exercise:
Figure 102. Test Case 3 - CREATE TABLESPACE Extract
A.4.7 Data Set Allocation Results
Figure 103 on page 173, using ISPF option 3.4, shows a data set list of the three
table spaces defined in this exercise to the SGDBTEST Storage Group. Using
standard volume selection criteria provided by SMS (see 5.3.4, “Storage Group”
on page 43), the data sets were evenly distributed across the three assigned disk
volumes.
Figure 103. Test Case 3 - ISPF Data Set List Display
CREATE DATABASE BTRANS
STOGROUP SGRV1CU0
...
CREATE DATABASE TESTDB
STOGROUP SGRV1CU0
...
CREATE TABLESPACE CHECKS
IN BTRANS
USING STOGROUP SGRV1CU0
PRIQTY 1024000
SECQTY 512000 ....
CREATE TABLESPACE TEST3
IN BTRANS
USING STOGROUP SGRV1CU0
PRIQTY 1024000
SECQTY 512000 ....
CREATE TABLESPACE TEST3
IN TESTDB
USING STOGROUP SGRV1CU0
PRIQTY 1024000
SECQTY 512000 ....
Menu Options View Utilities Compilers Help
-------------------------------------------------------------------------------
DSLIST - Data Sets Matching DB2D Row 1 of 4
Command ===> Scroll ===> HALF
Command - Enter "/" to select action Message Volume
-------------------------------------------------------------------------------
DB2D *ALIAS
DB2D.DSNDBC.BTRANS.CHECKS.I0001.A001 *VSAM*
DB2D.DSNDBC.BTRANS.TEST3.I0001.A001 *VSAM*
DB2D.DSNDBC.TESTDB.TEST3.I0001.A001 *VSAM*
DB2D.DSNDBD.BTRANS.CHECKS.I0001.A001 RV3CU3
DB2D.DSNDBD.BTRANS.TEST3.I0001.A001 RV1CU3
DB2D.DSNDBD.TESTDB.TEST3.I0001.A001 RV2CU3