The following Compound Boolean Selection (CBS) information section of the EOJ report contains information that compliments the already existing CBS statistics at EOJ. Following is an example of this CBS information section of the EOJ report:
Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB * Time: hh.mm.ss * General Utility * Release: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** 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 ‘
Sets Processed is the total number of sets processed by the MUF.
Sets Deleted Max Age is the number of sets which were deleted from the CBS buffer due to the CBS MAX AGE setting.
Sets Spilled is 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 wish to either increase the CBS buffer size or examine your applications for missing SELPR statements.
Sets Fetched is 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 shows the percent of CBS buffer max size that is being used by open sets.
CBSBFR MAX Percent Full is the high water mark for concurrent open sets.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|