MQ tables and index: CIUMQ1
Calculation of the space required for the DB2® tablespace and DB2 index for Websphere MQ data.
To calculate the space, in KB, to allocate for the DB2 tablespace and the DB2 index required for Websphere MQ data, you need to estimate the total number of rows.
This number is calculated from the following values; see Values required for
each CICS® region.
- NUM_MQ_PROG
- AVG_MQ
- PROG_TRAN_RATIO
- NUM_REGION_D
NUM_ROWS = (NUM_MQ_PROG * AVG_MQ *
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 DB2 space allocation for the MQ tablespace.
Tablespace | Row_Size | Percent_Free | PRIQTY | SECQTY |
---|---|---|---|---|
CIUMQD | 163 | 15 | ||
Indexes | ||||
XIMQD1 | 107 | 20 |