For the MUF_MEM_DETAIL (MMD) Dynamic System Table, one row exists for each MUF for most memory pools in existence, with the exception that some with the same descriptions are combined.
The MMD table is modeled after the Memory Use Summary Information page of the EOJ report. The MUF_MEM_DETAIL table contains individual pools. The MUF_MEM_SUMMARY table contains summary information. This table and the MUF_MEMORY_SUMMARY table are user-friendly ways of providing the information retrieved using the ?MEM console command.
64-bit MUF memory usage is not reflected in MUF_MEM_DETAIL table.
The MUF_MEM_DETAIL table contains the following columns:
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
MEM_AMOUNT |
DECIMAL(11,0) |
No |
Total memory allocated to this pool. |
|
MEM_DESC
|
CHAR(4) |
No |
A short description that can be blanks or repeated, as appropriate. For a list of these descriptions, refer to the information in the EOJ report. |
|
MEM_TYPE
|
CHAR(2) |
No |
Value of 24 or 31, indicating whether memory is 24-bit or 31-bit. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the MUF job name. |
|
OCCURENCES
|
SMALLINT |
No |
This column lists the number of occurrences of LUW, STME, STMR, and XCL (refer to the information in the EOJ report). |
|
Copyright © 2014 CA.
All rights reserved.
|
|