In the MUF_BUF_USE Dynamic System Table, one row exists for each buffer pool defined to the MUF. This includes the four standard buffer pools. The table contains the following columns:
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
BUFFER_SIZE |
INTEGER |
No |
Contains the buffer size for this pool. |
|
BUFFER_USED_1
|
DECIMAL(13,0) |
No |
Number of times a buffer in this pool was referenced for the first-time, after the buffer was read form DASD or copied from MRDF. |
|
BUFFER_USED_2
|
DECIMAL(11,0) |
No |
Number of times a buffer in this pool was referenced for a second time, after the buffer was read form DASD or copied from MRDF. |
|
BUFFER_USED_3
|
DECIMAL(11,0) |
No |
Number of times a buffer in this pool was referenced for a third time, after the buffer was read form DASD or copied from MRDF. |
|
BUFFER_USED_4
|
DECIMAL(11,0) |
No |
Number of times a buffer in this pool was referenced for a fourth time, after the buffer was read form DASD or copied from MRDF. |
|
BUFFER_USED_5
|
DECIMAL(13,0) |
No |
Number of times a buffer in this pool was referenced for a fifth time (and a sixth time, and a seventh time, and so on), after the buffer was read form DASD or copied from MRDF. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the MUF job name. |
|
NUMBER_OF_BUFFERS
|
INTEGER |
No |
Count of buffers currently specified for this pool. For the standard buffer pools, the count includes any FLEXPOOL buffers currently specified. |
|
POOL_NAME
|
CHAR(6) |
No |
The name of the standard pool. The standard pools are DATA, DATA_2, DXX, and IXX. |
|
Copyright © 2014 CA.
All rights reserved.
|
|