Db2 Memory DBM1 or DIST Attributes

Use the attributes to view the Db2 memory for the database address space (DBM1 or DIST).

24 Bit High Private (MB) Identifies the amount of private MVS storage below the 16 MB line (Db2 field name: QW0225HI). This storage is obtained from top downward, usually for authorized programs.

24 Bit Low Private (MB) Identifies the amount of private MVS storage below the 16 MB line (Db2 field name: QW0225LO). This storage is obtained from bottom upward, usually for unauthorized programs.

31 Bit Extended High Private (MB) Identifies the amount of private MVS storage above the 16 MB line (Db2 field name: QW0225EH). This storage is obtained from top downward, usually for authorized programs.

31 Bit Extended Low Private (MB) Identifies the amount of private MVS storage above the 16 MB line (Db2 field name: QW0225EL). This storage is obtained from bottom upward, usually for unauthorized programs.

31 Bit Storage Reserved for MVS Identifies the amount of storage available for operating system activity (Db2 field name: QW0225MV).

64 Bit Thread and System Only Aux (MB) Shows the amount of auxiliary storage in use for 64-bit private pools. This does not include buffer pool storage (Db2 field name: QW0225PriStg_Aux). This field only includes auxiliary slots occupied by pages that are paged out. This field is available in z/OS 1.10 (and maintenance) or later.

64 Bit Thread and System Only Real (MB) Shows the number of real-storage frames (4K) in use for 64-bit private pools. This is a subset of QW0225HVPagesInReal and does not include buffer pool storage (Db2 field name: QW0225PriStg_Real). This field is available in z/OS 1.10 (and maintenance) or later.

Address Space Name Shows the address space name (DBM1 or DIST) (Db2 field name: QW0225AN).

Aux 31 Bit in Use Shows the amount of auxiliary storage in use for 31-bit private pools. This value is available from z/OS V1.11.

Auxiliary Slots Used Shared Storage 64 Bit Shows the number of auxiliary slots used for 64-bit shared storage for this MVS LPAR (Db2 field name: QW0225SHRAUXSLOTS).

Auxiliary Storage in Use Shows the number of auxiliary slots that are in use. Each slot is 4 KB. This value is available from z/OS V1.11.

Auxiliary 4K Slot in Use 64 Bit Identifies the number of 4 KB auxiliary slots currently in use for 64-bit private storage. This value includes reserved auxiliary slots for pages that are paged in (Db2 field name: QW0225HVAUXSLOTS). This value is available from z/OS V1.11.

Available 31-Bit Storage Shows the total amount of storage available for storage manager pools (Db2 field name: QW0225AV).

Avg Thread Footprint (MB) Shows the current average memory usage of active user threads (allied threads and DBATs).

Average Thread Footprint private real (MB) Shows the current average real storage in use for private DBM1 storage of active user threads (allied threads + active and pooled DBATs). (Db2 field name: S225DTFR)

Average Thread Mem Usage Type 2 Shows the current average memory usage of active allied threads and the maximum number of active DBATs that existed. The formula used for this value is suited for Enterprise Resource Planning (ERP) systems.

Castout Buffers (MB) Shows the total storage for buffers needed for all castout engines. It is calculated as follows: (castout engines) * 128 * 1024.

Current Private High Addr 24 Bit Identifies the current high address of the 24-bit private region (Db2 field name: QW0225TP). It indicates the highest value (upper limit) of the private area of the Db2 database address space and the private area of the distributed data address space.

Current Private High Addr 31 Bit Identifies the current high address of the 31-bit private region (Db2 field name: QW0225EP).

Data Sharing Group The name of the Db2 data sharing group. It is an alphanumeric text string with a maximum of 8 characters.

Data Sharing Member The name of the Db2 data sharing member or the member name of the Db2 subsystem. It is an alphanumeric text string with a maximum of 8 characters.

DB2 Subsystem The name of the Db2 subsystem.

DB2 Version The version of the Db2 subsystem.

Fixed Storage (MB) Identifies the total amount of fixed storage (Db2 field name: QW0225FX).

Fixed Storage above (MB) Identifies the total amount of fixed storage above the 2 GB bar (Db2 field name: QW0225FA).

Getmained Storage (MB) Identifies the total storage acquired by GETMAIN (Db2 field name: QW0225GM). This includes space for virtual pools, EDM pool, compression dictionary, castout buffers, and the data space lookaside buffer, hiperpool control blocks, and data space buffer pool control blocks. This figure can be different from the sum of GETMAIN storage items shown in the statistics DBM1 storage, because DB2 does not produce grouping statistics for all GETMAIN storage.

Getmained Storage above (MB) Identifies the total storage acquired by GETMAIN (Db2 field name: QW0225GA). This includes space for the compression dictionary, and statement and DBD cache that can be used by the Environmental Descriptor Manager (EDM). This figure can be different from the sum of GETMAIN storage items shown in the statistics DBM1 storage, because Db2 does not produce grouping statistics for all GETMAIN storage.

Getmained Stack Storage (MB) Identifies the total GETMAINED storage allocated for program stack use (Db2 field name: QW0225GS). This includes total getmained stack storage, total 64-bit shared system agent stack, and total 64-bit shared non-system agent stack.

HWM Auxiliary 4K Slot in Use 64 Bit Shows the high water mark of auxiliary storage in use for 64-bit private pools. This value is available from z/OS V1.11.

HWM 64 bit real storage in use MB Shows the high water mark of real storage in use for 64-bit private pools. This value is available from z/OS V1.11.

Interval Start The start time of this interval.

Max Extended Region Size (MB) Identifies the maximum amount of MVS private storage available above the 16 MB line (Db2 field name: QW0225RG).

Max Number of Threads The maximum number of possible threads. It depends on the storage size and average memory usage of active user threads.

Max Number Possible Type 2 Threads The maximum number of possible threads. It depends on the storage size and average memory usage of active allied threads and the maximum number of active DBATs that existed.

MVS System ID The MVS system identifier.

Number of Real Frames in Use Identifies the amount of real-storage frames in use for 31-bit and 64-bit private pools (Db2 field name: QW0225RL).

Originating System ID The managed system name of the agent. It is an alphanumeric text string with a maximum of 32 characters; for example, DB91:SYS1:DB2.

Real 31 bit in use (MB) Shows the amount of real storage in use for 31-bit private pools. This value is available from z/OS V1.11.

Real 64 bit in use (MB) Shows the amount of real storage in use for 64-bit private pools. This value is available from z/OS V1.11.

Real 4K Frame in Use (MB) Shows the amount of real storage in use for 31-bit and 64-bit private pools; prior to Db2 10, it shows the real storage used by DBM1, in megabytes. (Db2 field name: SW0225RL)

Stack Storage In Use (MB) The amount of stack storage which is in use; this includes total stack storage in use, total 64-bit shared system agent stack in use, and total 64-bit shared non-system agent stack in use (Db2 field name: QW0225SU).

Storage Manager Control Block (MB) Identifies the total 64-bit storage allocated for storage manager control structures (Db2 field name: QW0225SM). This includes total 64-bit private storage for storage manager control structures, total 64-bit common storage for storage manager control structures, and total 64-bit shared storage for storage manager control structures.

Stor Res Must Complete Identifies the storage reserved for operation that must complete before Db2 is allowed to stop (Db2 field name: QW0225CR).

Storage Cushion Warning to Contract Storage cushion warning to contract (Db2 field name: QW0225SO).

Storage Cushion (MB) Identifies the storage reserved to allow Db2 to complete critical functions while short on storage. This includes the contract warning cushion, storage reserved for must-complete operations, and storage for MVS use.

Total 31-bit stack in use for system agents Shows the amount of 31-bit stack storage that is in use for system agents (Db2 field name: QW0225SS). This is a subset of QW0225SU.

Total Storage Below (MB) Shows the total DBM1 storage below 2 GB.

Total Storage Below (MB) Shows the total DIST storage below the bar.

Variable Storage (MB) The total variable storage available below the 31-bit bar. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225VR).

Variable Storage Above (MB) Identifies the total variable storage available above the 31-bit bar (Db2 field name: QW0225VA).