How to calculate the space required for the DB2® tablespace and DB2 index for CICS® data.
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.
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.
Tablespace | Row_Size | Percent_Free | PRIQTY | SECQTY |
---|---|---|---|---|
CIUCIC1 | 387 | 15 | ||
Indexes | ||||
XICICS11 | 317 | 20 |