Storage Consumption attributes

Use the Storage Consumption attributes to assess storage consumption issues for your Db2 version.

Agent Local Storage (MB) The amount of storage, in MB, allocated for agent-related local storage. This storage is used for operations such as sort. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225AL).

Agent System Storage (MB) The storage used by system agents. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225AS).

Auxiliary Storage in Use (MB) The auxiliary storage used by DBM1, in megabytes. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225AX).

Average Thread Footprint (MB) The current average memory usage of active allied threads and the maximum number of existing active DBATs. It is an alphanumeric text string with a maximum of 10 characters.

It is calculated as follows:

[(total variable storage)
- (total agent system storage)
- (amount of storage allocated for the local cache storage pool)]
/ [(active allied threads) + (active DBATs)]

Buffer Manager Data Manager Trace Table (MB) The storage used for Buffer Manager and Data Manager internal trace tables. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225TT).

Buffer Manager Storage CNTL Blocks (MB) The storage used for Buffer Manager Control Blocks. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225BB).

Castout Engines The number of engines available for data-sharing castout processing. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225CC).

Compression Dictionary (MB) The storage space, in megabytes, allocated for the compression dictionary. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225CD).

DBM1 Storage (MB) The total DBM1 storage. Valid value is an integer in the range 0 - 999999.

This includes:

  • Fixed length storage use
  • Getmained storage
  • Save areas
  • Variables

It is calculated as follows:

(total getmained storage)

+ (total variable storage)

+ (total fixed storage)

+ (total getmained stack storage)

Castout Buffers (MB) The total storage for buffers needed for all castout engines. Valid value is an integer in the range 0 - 999999.

It is calculated as follows:

(castout engines) * 128 * 1024

DB2ID The name of a Db2 subsystem.

DB2 Version The version of the Db2 system.

Deferred Write Engines The number of engines used for deferred write operations. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225DW).

Extended CSA Size (MB) The size of the common storage area (CSA) above the 16 MB line. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225EC).

Fixed Storage above (MB) The total amount of fixed storage above the 2 GB bar. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225FA).

Fixed Storage (MB) The total amount of fixed storage. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225FX).

Fixed Virtual 64 Bit Shared (MB) The amount of total fixed virtual shared storage above the 2 GB bar. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225SF).

GBP Write Engines The number of engines for group buffer pool writes. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225GW).

Getmained Stack Storage (MB) The total GETMAINED storage allocated for program stack use. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225GS).

Getmained Storage above (MB) The total storage acquired by GETMAIN above the 2 GB bar. 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. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225GA).

Getmained Storage (MB) The total storage acquired by GETMAIN. 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. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225GM).

Getmained Virtual 64 Bit Shared (MB) The amount of virtual shared storage acquired by GETMAIN above the 2 GB bar. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225SG).

Interval Start The date and time, as set on the monitored system, indicating the instance when the agent collects information.

Local Dynamic Statement Cache Control Blocks The storage for local dynamic statement cache blocks. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225SB).

Max Extended Region Size (MB) The maximum amount of MVS private storage available above the 16 MB line. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225RG).

Maximum Number of Threads The maximum number of possible threads. This depends on the storage size, the average memory usage of active user threads, and the maximum number of existing active DBATs. It is an alphanumeric text string with a maximum of 10 characters.

It is calculated as follows:

{(extended region size) - (31 bit extended low private)
- minimum (extended region size / 8, 200 * 1024 * 1024)
- [(total getmained storage) + (total getmained stack storage) + (total fixed storage)]}
/ (average thread footprint)

MVS System ID The MVS system identifier.

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.

Pipe Manager Subpool Storage (MB) The storage allocated to Pipe Manager for parallel query operations. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225PM).

P-Lock Notify Exit Engines The number of engines for data sharing P-lock/notify exit engines. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225PL).

Prefetch Engines The number of engines used for sequential, list, and dynamic prefetch. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225PF).

RDS OP Pool Storage (MB) The storage for RDS operations pool used for sort, prepare, and so on. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225RO).

Real Storage in Use (MB) The real storage used by DBM1, in megabytes. Valid value is an integer in the range 0 - 999999.

RID Pool Storage (MB) The storage for RID list processing, such as list prefetch, index ANDing, and ORing. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225RP).

Shared Memory Storage (MB) The amount of virtual shared memory storage above the 2 GB bar. Valid value is an integer in the range 0 - 999999.

Stack Storage In Use (MB) The amount of stack storage which is in use. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225SU).

Storage Cushion (MB) 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. Valid value is an integer in the range 0 - 999999.

Thread Copies of Cached SQL (MB) The amount of storage allocated for the local cache storage pool. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225SC).

Thread Copies of Cached SQL above HWM for Allocated Statements (MB) The statistics interval high-water mark (HWM) of allocated storage for thread copies in the local cache storage pool above the 2 GB bar. This is a subset of the counter Thread Copies of Cached SQL Statement Count. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225H2).

Thread Copies of Cached SQL above In Use (MB) The amount of storage used for thread copies in the local cache storage pool above the 2 GB bar. This is a subset of the counter Thread Copies of Cached SQL Statement Count. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225L2).

Thread Copies of Cached SQL above (MB) The amount of storage allocated for the local cache storage pool above the 2 GB bar. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225S2).

Thread Copies of Cached SQL Date at High Water Mark The timestamp at high-water storage (Db2 field name: QW0225HT).

Thread Copies of Cached SQL HWM for Allocated Statements (MB) The statistics interval high-water mark of the allocated storage for thread copies in the local cache storage pool. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225HS).

Thread Copies of Cached SQL In Use (MB) The amount of storage used for thread copies in the local cache storage pool. This is a subset of the total allocated storage for thread copies. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225LS).

Thread Copies of Cached SQL Statement Count The number of statements in the local cache storage pool. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225LC).

Thread Copies of Cached SQL Statement Count at High Water Mark The number of statements in the local cache storage pool at high storage time. Valid value is an integer in the range 0 - 999999 (Db2 field name: QW0225HC).

Variable Storage (MB) The total storage used by all variable pools. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225VR).

This includes storage used by:
  • System agents
  • Local agents
  • RID pool
  • Pipe manager subpool
  • Local dynamic statement cache control blocks
  • Local dynamic statement cache statement pool
  • Buffer and data manager trace tables

Variable Storage above (MB) The amount of variable storage available above the 2 GB bar. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225VA).

Variable Virtual 64 Bit Shared (MB) The amount of virtual shared variable storage above the 2 GB bar. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225SV).

24 Bit High Private (MB) The amount of private MVS storage below the 16 MB line. This storage is obtained from top downward, usually for unauthorized programs. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225HI).

24 Bit Low Private (MB) The amount of private MVS storage below the 16 MB line. This storage is obtained from bottom upward, usually for unauthorized programs. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225LO).

31 Bit Extended High Private (MB) The amount of private MVS storage above the 16 MB line. This storage is obtained from top downward, usually for authorized programs. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225EH).

31 Bit Extended Low Private (MB) The amount of private MVS storage above the 16 MB line. This storage is obtained from bottom upward, usually for unauthorized programs. Valid value is an integer in the range 0 - 9999999 (Db2 field name: QW0225EL).