Memory Use Summary Information

Following is an example of an EOJ Report that provides Memory Use Summary Information. The memory usage reported is that which exists at Multi-User Facility termination. It does not include memory allocated by the operating system. It does, however, include most memory allocated by ddb, but not all memory.
cdatvse
Following is an example of an EOJ Report that provides Memory Use Summary Information. The memory usage reported is that which exists at Multi-User Facility termination. It does not include memory allocated by the operating system. It does, however, include most memory allocated by
Datacom/DB
, but not all memory.
Date: mm/dd/ccyy    ********************************************************************************         Page:     1                     *                                 CA Datacom/DB                                * Time: hh.mm.ss      *                                General Utility                               *      Release: 12                     *                   Copyright © 2009 CA. All rights reserved.                  *               SPnn                     ********************************************************************************                                               MEMORY USE SUMMARY INFORMATION             Œ                              Ž                         ‘                       ’           DESC  LONG DESCRIPTION        24BIT-----ANY---64BIT (M=MEG,K=1024,ELSE BYTES) / OCCURRENCES                   DBMEMPR CALLS-----------   61       0     “                 ERROR, NON-SQL----------    1       0     ”             MAIN  DBMEMPR OWNED MEMORY, 24  128-K     0     •           MA31  DBMEMPR OWNED MEMORY,ANY    0       2--M           PC31  COMMON, POOL 0, ANY ----    0       8-K              MLB4  MUF STARTUP, 24 BIT ----   29-K     0           MLB1  MUF STARTUP, ANY -------    0     304-K           DCB   DCB/DTF, 24 BIT --------   32-K     0           DBIO  I/O CONTROL BLOCKS -----   32-K     0           4K31  MISC. 4K POOL, ANY -----    0      24-K           BDES  IXX/DXX/DATA/LXX BDES --    0      32-K           BUFS  IXX/DXX/DATA/EXP.BFRS --    0     564-K           DMP   PXX PRINT CACHE --------    0      33-K           MRDF  COVERED/VIRTUAL NOT DTSP    0      47-K           LOGB  LOG BUFFERS ------------    0     112-K           LOGT  LOG TRACE TABLE --------    0      32-K           DSM   DSM TRACE TABLE --------    0      32-K           MA64  DBMEMPR OWNED MEMORY, 64    0       0        6--M           IX64 IXX BFRS ----------------    0       0       81-K           MRDF  COVERED/VIRTUAL 64BIT       0       0      200-K
Œ
The first column is a short description that can be blanks and can be duplicated, if appropriate.
The second column is a long description that can be blanks and can be duplicated, if appropriate.
Ž
The third column is the amount of 24-bit requested memory, except for one case where it is a count.
The fourth column is the amount of any requested (usually 31-bit) memory, except for one case where it is a count.
The fifth column is the amount of any requested 64-bit memory.
The amount is presented as follows:
  • Numbers 1 through 9999 are printed with a blank terminator, for example, 9999 is printed as 9999 followed by a blank.
  • Numbers 10000 through 9999K are printed as n through nnnnK, rounded up.
  • Numbers 9999K plus one through 9999M are printed as n through nnnnM, rounded up.
  • Numbers above 9999M are printed with a G as the terminating character, rounded up.
This column lists the number of occurrences of LUW, STME, STMR, and XCL (see the descriptions in the table given in • below).
This line, the second line in z/OS but the first line in z/VSE, is a count of the number of memory manager requests in the 24-bit column and zero in the ANY column.
There are three possible counters which can be printed here. Each can be printed if they are non-zero counts. The three possible counters are as follows:
  • OUT OF STORAGE indicates the number of times a request to get memory could not be performed because no memory was available to satisfy the request.
  • ERROR, NON-SQL is a parameter error on a memory manager request. This counter is used only by Technical Support. Users have no control over it.
  • ERROR, SQL is a parameter error on a memory manager request. This counter is used only by Technical Support. Users have no control over it.
The MAIN and MA31 lines represent the amount of memory obtained from the operating system for use as dynamic memory. MAIN contains only 24-bit memory, while MA31 is ANY requested memory, generally 31-bit. This size is never reduced, that is, once obtained from the operating system this memory is used and reused as necessary.
The lines following the MAIN and MA31 lines represent a current breakdown of where the MAIN and MA31 memory is specifically allocated. Each line represents one or more pools. Some pools can occur more than once and some of those are collapsed for reporting purposes. General descriptions of the possible pools are as follows:
DESC
LONG DESCRIPTION
Explanation
DCB
DCB/DTF, 24 BIT --------
24-bit memory used for operating system control blocks.
DBIO
I/O CONTROL BLOCKS -----
24-bit memory used during I/O.
4K31
MISC. 4K POOL, ANY -----
Dynamic 4K pool of memory used for many items such as open areas, open tables, open data sets, open extents, open CXX base/area/table information.
ACCT
ACCOUNTING BFRS --------
Accounting tables buffers.
BDES
IXX/DXX/DATA/LXX BDES --
Index, data, and log buffer directory entries.
BUFS
IXX/DXX/DATA/EXP.BFRS --
Index, data, and expand buffers.
CAP
CXX CATALOG, DDL -------
Work areas during a CXX catalog or during SQL DDL statements.
CBSS
CBS SET
CBS set buffer
CBSW
CBS Work
Working storage for CBS
CNSB
CONSTRAINT BUILD OBJECT
SQL constraint processing memory, build object.
CNSC
CONSTRAINT CHECK ADD --
SQL constraint processing memory, check during add.
CNSR
CONSTRAINT READ TO EXEC
SQL constraint processing memory, read to execute.
CNST
CONSTRAINT TEMP. STORAGE
SQL constraint processing memory, temporary storage.
DBLG
SAVED LOG RECORD ---
Transaction backout saved log record.
DMP
PXX PRINT CACHE --------
Buffer to cache SQL and CBS trace and debugging information.
DSM
DSM TRACE TABLE ---
Space management trace table.
IX64
IXX BFRS -------
IXX buffers in 64-bit memory.
KYEL
CXX KEY/ELEMENT --------
CXX key and element memory for open tables.
LOGB
LOG BUFFERS ------------
Log buffers.
LOGT
LOG TRACE TABLE --------
Log trace/debugging table.
LUW
LOG.UNIT.WORK STORAGE --
SQL memory for logical unit of work control. Number of occurrences listed in OCCURRENCES column.
MA64
DBMEMPR OWNED MEMORY, 64
If 64-bit memory has been used by MUF, the report contains a MA64 line showing the total memory acquired in 64-bit.
MFR
RESTART WORK TABLE ---
Restart work tables and User Requirements Tables.
MLB1
MUF STARTUP, ANY -------
Done during MUF enable. Contains static control blocks allowed to be in 31-bit memory.
MLB4
MUF STARTUP, 24-BIT ----
Done during MUF enable. Contains static control blocks required to be in 24-bit memory.
MPZ
MPZ TRACE TABLE ---
(z/OS only)
Data Sharing, MUFplex, trace table.
MRDF
COVERED/VIRTUAL NOT DTSP
Control information for Covered/Virtual usage required in the MUF address space. Also contains buffers when running z/OS and not running Authorized.
MRDF
COVERED/VIRTUAL 64BIT
MRDF in 64-bit memory
MSC
MISCELLANEOUS SQL ------
SQL miscellaneous memory.
NEWC
NEW COPY WORK AREA ---
Work area for COMM NEWCOPY.
PC31
COMMON, POOL 0, ANY ----
Miscellaneous small uses of 31-bit memory.
PCOM
COMMON, POOL 0, 24-BIT -
Miscellaneous small uses of 24-bit memory.
PLN
PLAN STORAGE -----------
SQL plan memory.
PRCD
PROCEDURE RELATED ------
SQL procedure-related storage.
PRS
PARSER TEMP. STORAGE ----
SQL parser memory.
REQ
REQUEST SQL STORAGE ----
SQL request memory.
SASV
STXIT WORK AREAS -------
z/VSE program failure work areas.
SCF1
SECURITY FAST PATH-USER
Security fast path for users.
SCF2
SECURITY FAST PATH-TABLE
Security fast path for tables.
SPILL
LOG SPILL BUFFERS
Buffers used for spilling the log to the RXX.
STMC
STMT PREPARE: CURSOR UPDSQL
SQL statement prepare - cursor update.
STMD
STMT EXECUTE: DYN-CURSOR
SQL statement execution - dynamic cursor.
STME
STMT EXECUTE: STMT COPY
SQL statement execution cache. Number of occurrences listed in OCCURRENCES column.
STMN
STMT EXECUTE: NON-STATIC
SQL statement execution - non-static.
STMP
STMT PREPARE: GENERAL --
SQL statement prepare - general use.
STMR
STMT READ PROCESSING ---
SQL statement read processing. Number of occurrences listed in OCCURRENCES column.
STMS
STMT SEARCH: DB2 MODE --
(z/OS only)
SQL statement search - DB2 mode statements.
TSKW
TASK (RWTSA) WORK AREAS
Work areas associated with each task area being used.
VEW
VIEW RESOLUTION --------
SQL view resolution.
VPEP
DD VPE GLOBAL ----------
Datadictionary global work area.
XCF
MVS XCF USAGE ----------
Contains the work areas required for XCF communication in z/OS. This occurs when using XCF to run jobs on an image other than the one on which the Multi-User Facility is executing or during Data Sharing.
XCL
SQL C STACK, TASK WORK -
Work areas for SQL task processing. Number of occurrences listed in OCCURRENCES column.
XES1
DATASHARING (MUFPLEX)
(z/OS only)
Data Sharing, MUFplex, trace/debugging table.