BUF_CUR_PERC_FULL

SMALLINT

No

This is the percentage of the Compound Boolean Selection (CBS) buffer size specification currently being used for open set definitions.

BUF_MAX_PERC_FULL

SMALLINT

No

This is the high water percentage of the Compound Boolean Selection (CBS) buffer size specification that was used for open set definitions. Once the CBS buffer percent used reaches 100, it causes the least recently used sets to be spilled to the CBS index.

CUR_USED_SET_MEM

INTEGER

No

The amount of memory being used for open set definitions.

DURATION_AT_SPILL

CHAR(6)

Yes

The duration or length of time the most recently spilled set existed before it was spilled, in the format mmm:ss. If no sets have been spilled, this column is null.

MAX_USED_SET_MEM

INTEGER

No

The maximum amount of memory used for open set definitions. The maximum amount of memory used is limited by the Compound Boolean Selection (CBS) buffer specification. If this limit is reached, open sets must be spilled to the CBS index.

MUF_NAME

CHAR(8)

No

Name of the MUF specified in the MUF Multi-User startup option or the MUF job name.

SETS_DEL_MAX_AGE

DECIMAL(11,0)

No

The number of open sets in the Compound Boolean Selection (CBS) buffer that were deleted because of the CBS max age specification. If this number is not zero, it can indicate that applications are not releasing sets when they are finished with them.

SETS_FETCHED

DECIMAL(11,0)

No

Count of 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 the SELPR command in user programs that is causing sets which are no longer in use to be paged out.

SETS_PROCESSED

DECIMAL(11,0)

No

Specifies the number of sets processed by Compound Boolean Selection (CBS).

SETS_SPILLED

DECIMAL(11,0)

No

Count of sets which had to be paged to the Compound Boolean Selection (CBS) index. This is an interaction between the specified CBS buffer size and the number and size of open CBS sets. If SETS_SPILLED in not zero, you might want to increase the CBS buffer size or examine your applications for missing SELPR commands.

SETS_TEMP_INDEX

DECIMAL(11,0)

No

The number of sets requiring a temporary index.

SPILLED_JOB_NAME

CHAR(8)

Yes

This is the job name that owned the most recently paged-out set, because the Compound Boolean Selection (CBS) buffer was full. If no sets have been spilled, this column is null.

SPILLED_UIB

CHAR(32)

Yes

This is the 32 UIB associated with the most recently paged-out set, because the Compound Boolean Selection (CBS) buffer was full. If no sets have been spilled, this column is null.

TEMP_INDEX_ENTRIES

DECIMAL(11,0)

No

The total number of temporary index entries built to support set selection criteria.