CICS IA plug-in for CICS Explorer® Resource table: CIURESTB/X
Calculation of the space required for the DB2® table space and the DB2 indexes required for the CICS® region information.
The default values set by CICS IA
are larger than required. To calculate the space to allocate for the DB2 table space and the DB2 indexes required for CICS region information, estimate
the total number of rows.
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 table spaces and indexes for the Resource table space.
Table space | 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 table spaces and indexes for the Resource table space.
Table space | Row_Size | Percent_Free | PRIQTY | SECQTY |
---|---|---|---|---|
CIURSRC | 273 | 15 | ||
Indexes | ||||
X01RES01 | 273 | 2 | ||
X01RES02 | 255 | 2 | ||
X01RES03 | 8 | 2 |