Program resource tables and index: CIURPROG

Calculation of the space required for the Db2® tablespace and Db2® index for the program resource data.

To calculate the space, in KB, to allocate for the Db2® tablespace and the Db2® index required for program resource data, you need to estimate the total number of rows.

Calculate this number from the following values:
  • NUM_CICS_PROG
  • NUM_REGION_D
Calculate the number of rows for the Db2® table as follows:
NUM_ROWS = (NUM_CICS_PROG * NUM_REGION_D) 

Use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Worksheet for program detail resource table to calculate the PRIQTY and SECQTY as described in Db2 space allocation.

Table 1. Worksheet for program detail resource table
Tablespace Row_Size Percent_Free PRIQTY SECQTY
CIUPROG 339 15
Indexes
XPROGA 20 20