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® 7.1 use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Worksheet for Resource table space using Db2 7.1 to calculate the PRIQTY and SECQTY as described in Calculation for PRIQTY for table spaces and indexes for the Resource table space.

Table 1. Worksheet for Resource table space using Db2® 7.1
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® 8.1 or later use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Worksheet for Resource table space using IBM Db2 8.1 to calculate the PRIQTY and SECQTY as described in Calculation for PRIQTY for table spaces and indexes for the Resource table space.

Table 2. Worksheet for Resource table space using IBM® Db2® 8.1
Table space Row_Size Percent_Free PRIQTY SECQTY
CIURSRC 273 15
Indexes
X01RES01 273 2
X01RES02 255 2
X01RES03 8 2