CICS IA plug-in for CICS Explorer® Resource table: CIURESTB/X

Calculation of the space required for the DB2® tablespace 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 tablespace 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 tablespaces and indexes for the Resource tablespace.

Table 1. Worksheet for Resource tablespace using DB2 V7.1
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.

Table 2. Worksheet for Resource tablespace using DB2 V8.1
Tablespace Row_Size Percent_Free PRIQTY SECQTY
CIURSRC 273 15    
Indexes        
X01RES01 273 2    
X01RES02 255 2    
X01RES03 8 2