CSECT Module Scanner tables

The default values set by CICS® IA are larger than required. To calculate the space to allocate for the DB2® tablespace and the DB2 indexes required for the CSECT Module Scanner, estimate the total number of rows.

There are three tables in two tablespaces:

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 above, 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 calculation below:

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 CSECT Module Scanner tablespace.

Table 1. Worksheet for CSECT Module Scanner tablespace
Tablespace Row_Size Percent_Free PRIQTY SECQTY
CIUCSSD        
Program 123 15    
CSECT 240 15    
Indexes        
X4CSSDA 86 20    
X4CSSDB 94 20    
X4CSSDE 8 20