Transient data queue resource tables and index: CIURTDQ
Calculation of the space required for the Db2® tablespace and Db2® index for the transient data queue resource data.
To calculate the space, in KB, to allocate for the Db2® tablespace and the Db2® index required for transient data queue resource data, you need to estimate the total number of rows.
Calculate this number from the following values:
- NUM_CICS_TDQ
- NUM_REGION_D
Calculate the number of rows for the Db2® table as follows:
NUM_ROWS = (NUM_CICS_TDQ * NUM_REGION_D) Use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Worksheet for the TDQUEUE detail resource table to calculate the PRIQTY and SECQTY as described in Db2 space allocation.
| Tablespace | Row_Size | Percent_Free | PRIQTY | SECQTY |
|---|---|---|---|---|
| CIUTDQ | 291 | 15 | ||
| Indexes | ||||
| XTDQUEA | 16 | 20 |