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 Table 1 to calculate the PRIQTY and SECQTY as described in DB2 space allocation for the CSECT Module Scanner table space.

Table 1. Worksheet for 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