In the MUF_CBS_OLD_SETS Dynamic System Table, one row exists for each of the ten oldest open Compound Boolean Selection (CBS) sets that reside in the CBS buffer and have therefore not been spilled. There can be fewer than ten rows in this table if there are less than ten sets currently in the CBS buffer. The same set can appear more than once in this table if the set is used while your query is running and after its use is in the ten least recently used sets.
The MUF_CBS_OLD_SETS Dynamic System Table contains the following columns:
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
JOB_NAME
|
CHAR(8) |
No |
The name of the job that opened this set. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the MUF job name. |
|
RUN_UNIT
|
INTEGER |
No |
The internal run unit assigned to the job that opened this set. |
|
SEQUENCE_NUMBER
|
SMALLINT |
No |
A sequence number of from one to ten (1—10). |
|
SET_AGE
|
CHAR(6) |
No |
The amount of time that has passed since this set was last used, in the format mmm:ss. |
|
SET_NUMBER
|
INTEGER |
No |
This is a sequence number assigned when a set is created. For example, a number of 110 represents the one hundred and tenth set created during the life of this MUF. |
|
UIB
|
CHAR(32) |
No |
The User Information Block (UIB) associated with this set. |
|
Copyright © 2014 CA.
All rights reserved.
|
|