CICS tables and index: CIUCICS1 and CIUCICSX

How to calculate the space required for the DB2® tablespace and DB2 index for CICS® data.

To calculate the space, in KB, to allocate for the DB2 tablespace and the DB2 index required for CICS data, estimate the total number of rows. This number is calculated from the following values; see Values required for each CICS region:
  • NUM_CICS_PROG
  • AVG_EXEC_SHORT
  • AVG_EXEC_LONG
  • PROG_TRAN_RATIO
  • NUM_REGION_D
Calculate the number of rows for the CICS table as follows:
NUM_ROWS = (NUM_CICS_PROG * AVG_EXEC_SHORT
            * PROG_TRAN_RATIO * NUM_REGION_D) +
           (NUM_CICS_PROG * AVG_EXEC_LONG 
            * PROG_TRAN_RATIO * NUM_REGION_D)  

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 Figure 1.

Table 1. Worksheet for CICS tablespace using DB2 V7.1
Tablespace Row_Size Percent_Free PRIQTY SECQTY
CIUCIC1 315 15    
Indexes        
XICICS11 245 20    

If you are using DB2 V8.1, 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 Figure 1.

Table 2. Worksheet for CICS tablespace using DB2 V8.1
Tablespace Row_Size Percent_Free PRIQTY SECQTY
CIUCIC1 387 15    
Indexes        
XICICS11 317 20    

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//ciucics.html