CSECT Module Scanner tables
The default values set by CICS® IA are larger than required. To calculate the space to allocate for the Db2® table space and the Db2® indexes required for the CSECT Module Scanner, estimate the total number of rows.
There are three tables in two table spaces:
CIU_PROGRAM_INFO: The number of rows for this table is the number of programs that are in all the application load modules.
CIU_CSECT_INFO: The number of rows for this table is the number of programs defined for the CIU_PROGRAM_INFO, multiplied by the average number of CSECTS per program.
CIU_TRNSLATORS: This table is static. It holds the program product number for compilers and translators with the corresponding names. The number is set to 50. The default values for CICS® IA PRIQTY and SECQTY for this table are larger than required. Set them to the value you obtain from the following calculation:
Use the value calculated for NUM_ROWS and the values for ROW_SIZE and PERCENT_FREE in Worksheet for CSECT Module Scanner table space to calculate the PRIQTY and SECQTY as described in Db2 space allocation for the CSECT Module Scanner table space.
| Table space | Row_Size | Percent_Free | PRIQTY | SECQTY |
|---|---|---|---|---|
| CIUCSSD | ||||
| Program | 123 | 15 | ||
| CSECT | 240 | 15 | ||
| Indexes | ||||
| X4CSSDA | 86 | 20 | ||
| X4CSSDB | 94 | 20 | ||
| X4CSSDE | 8 | 20 |