COMM (Communicate with MUF) › COMM EOJ (End MUF Processing) › Summary Reports Produced by the MUF During its EOJ Process › Compound Boolean Selection (CBS) Information Example

Compound Boolean Selection (CBS) Information Example

The following Compound Boolean Selection (CBS) information section of the EOJ report contains information that compliments the already existing CBS statistics at EOJ.

                                                  CBS INFORMATION
 
                            SETS PROCESSED               561        SETS DELETED MAX AGE          0    
                            SETS SPILLED                   0        SETS FETCHED                  0 
                            CBSBFR CURRENT PERCENT FULL    0        CBSBFR MAX PERCENT FULL       0

This page of the report shows an example of the additional CBS information in the EOJ report:

SETS PROCESSED

Displays the total number of sets processed by the MUF.

SETS DELETED MAX AGE

Displays the number of sets which were deleted from the CBS buffer due to the CBS MAX AGE setting.

SETS SPILLED

Displays the number of sets which had to be paged to the CBS index. This is an interaction between the specified CBS buffer size and the number and size of open CBS sets. If Sets Spilled is non-zero, you might want to either increase the CBS buffer size or examine your applications for missing SELPR statements.

SETS FETCHED

Displays the number of times a spilled set was referenced to retrieve more rows. The ratio between Sets Spilled and Sets Fetched can be used to understand if sets that are truly in use are being spilled to the CBS index, or if it is an absence of SELPR in user programs which is causing sets, that are no longer in use, to be paged out.

CBSBFR CURRENT PERCENT FULL

Displays the percent of CBS buffer max size that is being used by open sets.

CBSBFR MAX PERCENT FULL

Displays the high water mark for concurrent open sets.