Calculation of the space required for the DB2® tablespace and the DB2 indexes required for the CICS® region information.
In this example, the number of rows calculated for the CICS table in CICS tables and indexes section can be used.
If you are using DB2 V7.1 use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Table 1 to calculate the PRIQTY and SECQTY as described in Calculation for PRIQTY for tablespaces and indexes for the Resource tablespace.
Tablespace | Row_Size | Percent_Free | PRIQTY | SECQTY |
---|---|---|---|---|
CIURSRC | 201 | 15 | ||
Indexes | ||||
X01RES01 | 201 | 2 | ||
X01RES02 | 183 | 2 | ||
X01RES03 | 8 | 2 |
If you are using DB2 V8.1 or later use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Table 2 to calculate the PRIQTY and SECQTY as described in Calculation for PRIQTY for tablespaces and indexes for the Resource tablespace.
Tablespace | Row_Size | Percent_Free | PRIQTY | SECQTY |
---|---|---|---|---|
CIURSRC | 273 | 15 | ||
Indexes | ||||
X01RES01 | 273 | 2 | ||
X01RES02 | 255 | 2 | ||
X01RES03 | 8 | 2 |