Calculation of the space required for the DB2® tablespace and DB2 index for IMS™ data.
To calculate the space, in KB, to allocate for the DB2 tablespace and the DB2 index required for IMS data, you need to estimate the total number of rows.
NUM_ROWS = (NUM_IMS_PROG * AVG_IMS *
PROG_TRAN_RATIO * NUM_REGION_D)
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 for the IMS tablespace.
Tablespace | Row_Size | Percent_Free | PRIQTY | SECQTY |
---|---|---|---|---|
CIUIMSD | 127 | 15 | ||
Indexes | ||||
XIIMSD1 | 69 | 20 |