Previous Topic: SQL Code Summary InformationNext Topic: MUF EOJ Log Status Information


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 MUF termination. It does not include memory allocated by the operating system. It does, however, include most memory allocated by CA Datacom/DB, but not all memory.

MEMORY USE SUMMARY INFORMATION DESC LONG DESCRIPTION 24BIT-----ANY---64BIT (M=MEG,K=1024,ELSE BYTES) / OCCURRENCES PROGRAM MEMORY (AT EOJ)- 58-K 408-K 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 INDEX BFRS ------------- 0 0 81-K MRDF COVERED/VIRTUAL 64BIT 0 0 200-K

This page of the report provides the following information:

DESC

Displays a short description that can be blanks and can be duplicated, if appropriate.

LONG DESCRIPTION

Displays a long description that can be blanks and can be duplicated, if appropriate.

24BIT

Displays the amount of 24-bit requested memory, except for one case where it is a count.

ANY

Displays the amount of any requested (usually 31-bit) memory, except for one case where it is a count.

64BIT

Displays the amount of any requested 64-bit memory. The amount is presented as follows:

OCCURRENCES

Displays the number of occurrences of LUW, STME, STMR, and XCL (see the descriptions in the following table).

PROGRAM MEMORY (AT EOJ)

In z/OS, this line shows the amount of memory for most (but not all) programs.

DBMEMPR CALLS

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.

ERROR, NON-SQL

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:

MAIN and MA31

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.

Remaining lines

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

CDC

Change Data Capture

Working storage for Change Data Capture

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

INDEX BFRS -------

 

Index 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.

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 MUF 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.