Db2 Memory attributes

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

4-Bit Aux Frames Shared Stack Identifies the number of auxiliary slots (4K) in use for 64-bit shared stack storage. This is recorded at the subsystem level. This field only includes auxiliary slots occupied by pages that are paged out (Field name: QW0225ShrStkStg_Aux). This field is available in z/OS 1.10 (and maintenance) or later.

Shared stack storage (MB) Identifies the number of real-storage frames (4K) in use for 64-bit shared stack storage. This is recorded at the subsystem level (Field name: QW0225ShrStkStg_Real). This field is available in z/OS 1.10 (and maintenance) or later.

64-Bit Shared Storage (MB) Identifies the number of 64-bit shared memory pages allocated for this MVS LPAR (this count includes hidden pages) (Field name: QW0225SHRPAGES).

Active and Disconnect DBATs Identifies the number of active and disconnected DBAT threads (Field name: QW0225DB).

Active Threads Identifies the number of active allied threads (Field name: QW0225AT).

Average Thread Footprint 64-bit common real Shows the current average real storage in use for common storage of active user threads (allied threads + active and pooled DBATs).

Average Thread Footprint (MB) Shows the current average real storage in use for subsystem shared storage of active user threads (allied threads + active and pooled DBATs).

Agent Local Storage (MB) The amount of storage, in MB, allocated for agent-related local storage (Field name: QW0225AL). This storage is used for operations such as sort. Valid value is an integer in the range 0 - 9999999. This field includes the total agent local storage (31-bit DBM1 private variable pools) and total agent local storage (64-bit shared variable pools).

Agent System Storage (MB) Identifies the storage used by system agents (Field name: QW0225AS). This field includes the total system agent storage (31-bit DBM1 private variable pools) and the total system agent storage (64-bit shared variable pools).

Aux Storage Used 64-Bit shared (MB) Shows the amount of auxiliary storage used for 64-bit shared storage for this MVS LPAR (including reserved auxiliary slots for pages that are paged in).

Aux Stg In Use 64-Bit Common (MB) Shows the number of auxiliary slots (4K) in use for 64-bit common storage. This is recorded at the subsystem level. This field only includes auxiliary slots occupied by pages that are paged out (Field name: QW0225ComStg_Aux). This field is available in z/OS 1.10 (and maintenance) or later.

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

Auxiliary Storage in use (MB) Shows the number of 4 KB auxiliary slots that are used for 64-bit shared stack storage. This value is recorded at the subsystem level. It includes only auxiliary slots that are occupied by pages that are page out. This field is available in z/OS 1.10 (and maintenance) or later.

Buffer Manager Storage Control Blocks (MB) Identifies the total storage used for page set control blocks (Field name: QW0225BB).

Castout Engines Identifies the number of engines available for data-sharing castout processing (Field name: QW0225CE).

Common Fixed Pool Above (MB) Identifies the amount of storage allocated for 64-bit common fixed pool storage (Field name: QW0225FCG).

Common Fixed Pool Below (MB) Identifies the amount of storage allocated for 31-bit common fixed pool storage (Field name: QW0225FC).

Common Getmained Above (MB) Identifies the amount of storage allocated for 64-bit common getmained storage (Field name: QW0225GCG).

Common Getmained Below (MB) Identifies the amount of storage allocated for 31-bit common getmained storage (Field name: QW0225GC).

Common Storage Manager Control Block Above (MB) Identifies the amount of storage allocated for 64-bit common storage for storage manager control structures (Field name: QW0225SMC).

Common Variable Pool Above (MB) Shows the amount of storage allocated for 64-bit common variable pool storage (Field name: QW0225VCG).

Common Variable Pool Below (MB) Identifies the amount of storage allocated for 31-bit common variable pool storage (Field name: QW0225VC).

Compression Dictionary Identifies the storage space allocated for the compression dictionary (Field name: QW0225CD).

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

Deferred Write Engines Identifies the number of engines used for deferred write operations (Field name: QW0225DW).

Dynamic Statement Cache Control Block (MB) Identifies the amount of storage used for dynamic statement cache control blocks above the 2 GB bar (Field name: QW0225S2).

Extended CSA Size (MB) Identifies the size of the common storage area (CSA) above the 16 MB line (Field name: QW0225EC).

GBP Write Engines Identifies the number of engines for group buffer pool writes (Field name: QW0225GW).

HWM 64-Bit Shared Storage (MB) Identifies the high water mark number of 64-bit shared bytes for this MVS LPAR (Field name: QW0225SHRGBYTES).

HWM Requested Non Shr Dyn SQL (MB) Shows statistics interval high-water mark (HWM) of requested non-shareable storage for dynamic SQL statements used by active threads. For DB2 10 or later, this value is related to shared agent local variable pools above the bar.

HWM Shr Dyn SQL (MB) Identifies the statistics interval high-water mark (HWM) of requested shareable storage for dynamic SQL statements used by active threads.

Interval Start The start time of this interval.

IRLM Current used 31-bit private Shows the total amount of 31-bit private storage that is currently in use by Internal Resource Lock Manager (IRLM) pools (Field name: QW0225I_BBPVT). This value is the total of all 31-bit IRLM private pools.

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM Current used 64-bit common Shows the total amount of 64-bit common storage that is currently in use by Internal Resource Lock Manager (IRLM) pools (Field name: QW0225I_ABCSA). This value is the total of all 64-bit common IRLM pools.

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM Current used 64-bit private Shows the total amount of 64-bit private storage in use by Internal Resource Lock Manager (IRLM) pools (Field name: QW0225I_ABPVT).

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM Current used ECSA Shows the total amount of Extended Common Service Area (ECSA) storage in use by Internal Resource Lock Manager (IRLM) pools.

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM ECSA high water mark Shows the high water mark of Extended Common Service Area (ECSA) storage allocated by Internal Resource Lock Manager (IRLM) pools.

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM HWM for 31-bit private (MB) Shows the high water mark of 31-bit private storage that has been in use (Field name: QW0225I_BBPVH). This value is the total amount of all 31-bit private IRLM pools.

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM HWM for 64-bit common (MB) Shows the high water mark of 64-bit common storage that has been in use. This value is the total of all 64-bit common IRLM pools (Field name: QW0225I_ABCSH).

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM HWM for 64-bit private Shows the high water mark of 64-bit private storage allocated by IRLM pools (Field name: QW0225I_ABPVH).

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM Threshold virtual 31-Bit Shows the threshold of 31-bit virtual storage available for normal IRLM execution. Only requests for storage by "must complete" tasks will be granted if this threshold is exceeded (Field name: QW0225I_BPMAX).

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

IRLM Threshold virtual 64-Bit Shows the threshold of 64-bit virtual storage available for normal IRLM execution. Only requests for storage by "must complete" tasks will be granted if this threshold is exceeded.

It can show the following values:
N/A
Not applicable is shown if Db2 never produces a counter value in a specific context. Examples are:
  • A counter is not available in one Db2 version.
  • Counters are mutually exclusive.
N/C
Not calculated is shown for a derived field where the value cannot be calculated or is useless. Examples are:
  • A divide by zero (percentages, ratios).
  • Suppression of negative elapsed time values.
  • Required counter values for calculation marked as N/A or N/P.
  • Insufficient data or small counter values to allow significant statements (meaningless or misleading averages).
N/P
Not present is shown for a field where Db2 can present values, but does not in this instance. Examples are:
  • When counter values are not generated because of operational conditions (a trace class is not active).
  • An application does not provide a value because it is optional.

Log Manager Control frames Aux (MB) The number of frames in auxiliary storage that are being used for log manager control structures.

Log Manager Control frames REAL (MB) The number of frames in real storage that are being used for log manager control structures.

Log Manager Wrt buff frames REAL (MB) The number of frames in real storage that are being used for log manager write buffers.

MVS System ID The MVS system identifier.

Number of active parallel child threads Shows the number of active parallel child threads.

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.

P-Lock Notify Exit Engines Identifies the number of data sharing P-Lock engines and Notify Exit engines (Field name: QW0225PL).

Prefetch Engines Identifies the number of engines used for sequential, list, and dynamic prefetch (Field name: QW0225PF).

RID Pool Storage (MB) Identifies the storage for RID list processing such as list prefetch, index ANDing and ORing (Field name: QW0225RP).

Real Frames Common 64-Bit Identifies the number of real-storage frames (4K) in use for 64-bit common storage. This is recorded at the subsystem level (Field name: QW0225ComStg_Real). This field is available in z/OS 1.10 (and maintenance) or later.

Real Storage in use (MB) Shows the total amount of real storage in use for 64-bit shared storage. This is recorded at the subsystem level. This field is available in z/OS 1.10 (and maintenance) or later.

Shared Agent Local Storage (MB) Shows the amount of storage allocated for agent-related 64-bit local storage (Field name: QW0225ALG).

Shared Agent Non-System Storage (MB) Shows the amount of 64-bit storage used by non-system agents. It is the difference between the Total Agent Local Storage (Field name: QW0225ALG) and the Total Agent System Storage (Field name: QW0225ASG).

Shared Agent System Storage (MB) Shows the amount of 64-bit storage used by system agents (Field name: QW0225ASG).

Shared Fixed Storage 64-bit (MB) Identifies the amount of total fixed virtual shared storage above the 2 GB bar (Field name: QW0225SF).

Shared Getmained Storage (MB) Identifies the amount of virtual shared storage acquired by GETMAIN above the 2 GB bar (Field name: QW0225SG).

Shared Memory Objects Identifies the number of shared memory objects allocated for this MVS LPAR (Field name: QW0225SHRNMOMB).

Shared Non-System Agent Stack Storage (MB) Shows the amount of 64-bit shared storage allocated for non-system agent stack use.

Shared Non-System Agent Stack Storage in Use (MB) Shows the amount of 64-bit shared non-system agent stack that is in use.

Shared Pages Backed in Real Storage 64 Bit Shows the number of 64-bit shared pages backed in real storage (4K pages) for this MVS LPAR (Field name: QW0225SHRINREAL).

Shared Pages Paged In from Aux Storage 64 Bit Identifies the number of 64-bit shared pages paged in from auxiliary storage for this MVS LPAR (Field name: QW0225SHRPAGEINS).

Shared Pages Paged Out from Auxiliary Storage 64 Bit Shows the number of 64-bit shared pages paged out to auxiliary storage for this MVS LPAR (Field name: QW0225SHRPAGEOUTS).

Shared System Agent Stack Storage (MB) Shows the amount of 64-bit shared storage allocated for system agent stack use.

Shared Storage Manager Control Block (MB) Shows the amount of 64-bit shared storage allocated for storage manager control structures.

Shared Variable Storage (MB) Identifies the amount of virtual shared variable storage above the 2 GB bar (Field name: QW0225SV).

Stack Storage In Use (MB) Shows the amount of 64-bit shared system agent stack that is in use.

Shared thread and system (MB) Shows the number of real-storage frames (4K) in use for 64-bit shared storage. This does not include shared stack storage (Field name: QW0225ShrStg_Real). This is recorded at the subsystem level. This field is available in z/OS 1.10 (and maintenance) or later.

Subsystem 64-bit Shared Thd and Sys Shows the number of auxiliary slots (4K) in use for 64-bit shared storage. This does not include shared stack storage (Field name: QW0225ShrStg_Aux). This is recorded at the subsystem level. 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.

Thread Copies of Cached SQL Date at HWM Identifies the timestamp at high-water storage (Field name: QW0225HT).

Thread Copies of Cached SQL Statement Count Identifies the number of statements in the local cache storage pool (Field name: QW0225LC).

Thread Copies of Cached SQL Statement Count at HWM Identifies the number of statements in the local cache storage pool at high storage time (Field name: QW0225HC).

Total Agent Non-System Storage (MB) Shows the total Agent Non-System Storage. It is the difference between the Total Agent Local Storage (QW0225AL) and the Total Agent System Storage (QW0225AS).

Total Alloc Shr Static SQL (MB) Identifies the total shareable storage allocated for static SQL statements.

Total Allocated Shareable Storage for dynamic (MB) Identifies the total shareable storage allocated for dynamic SQL statements used by active threads.

Total Requested Non Shr Dyn SQL (MB) Identifies the total non-shareable storage requested for dynamic SQL statements used by active threads. For DB2 10 or later, this value is related to shared agent local variable pools above the bar.

Total Requested Shr Dyn SQL (MB) Identifies the total shareable storage requested for dynamic SQL statements used by active threads.