DIST and MVS Storage Below 2 GB

This topic shows detailed information about "Statistics - DIST and MVS Storage Below 2 GB".

Statistics - DIST and MVS Storage Below 2 GB

The field labels shown in the following sample layout of "Statistics - DIST and MVS Storage Below 2 GB" are described in the following section.

DIST AND MVS STORAGE BELOW 2 GB                         QUANTITY
--------------------------------------------  ------------------
TOTAL DIST STORAGE BELOW 2 GB           (MB)              133.03
 TOTAL GETMAINED STORAGE                (MB)                0.04
 TOTAL VARIABLE STORAGE                 (MB)               14.21
   NUMBER OF ACTIVE CONNECTIONS                           967.74
   NUMBER OF INACTIVE CONNECTIONS                           0.00
 TOTAL FIXED STORAGE                    (MB)                0.85
 TOTAL GETMAINED STACK STORAGE          (MB)              117.92
   TOTAL STACK STORAGE IN USE           (MB)              117.89
     SYSTEM AGENT STACK STORAGE IN USE  (MB)               15.73
STORAGE CUSHION                         (MB)              358.03

24 BIT LOW PRIVATE                      (MB)                0.23
24 BIT HIGH PRIVATE                     (MB)                0.21
24 BIT PRIVATE CURRENT HIGH ADDRESS           0000000000042000
31 BIT EXTENDED LOW PRIVATE             (MB)                5.14
31 BIT EXTENDED HIGH PRIVATE            (MB)              147.14
31 BIT PRIVATE CURRENT HIGH ADDRESS           0000000018325000
EXTENDED REGION SIZE (MAX)              (MB)             1666.00

TOTAL DIST STORAGE BELOW 2 GB (MB)

Total DIST storage below the bar. This includes:

Fixed length storage use
Getmained storage
Save areas
Variables

Field Name: SW0225DI

TOTAL GETMAINED STORAGE (MB)

Start of change Total storage acquired by GETMAIN. This includes space for virtual pools, EDM pool, compression dictionary, castout buffers, and the data space lookaside buffer, and data space buffer pool control blocks. End of change

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.

Field Name: QW0225GM

TOTAL VARIABLE STORAGE (MB)

Total storage used by all variable pools. 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
A list of objects in restricted state including the new PRO state. If consumption of this storage pool is high, review restrictive exception state of database objects and check whether they can be resolved or reduced.

Field Name: QW0225VR

NUMBER OF ACTIVE CONNECTIONS

The number of active connections, or active and disconnected DBAT threads.

Field Name: SACDBATS

NUMBER OF INACTIVE CONNECTIONS

The current number of type 2 inactive connections.

Field Name: QDSTCIN2

TOTAL FIXED STORAGE (MB)

Total amount of fixed storage.

Field Name: QW0225FX

TOTAL GETMAINED STACK STORAGE (MB)

Total GETMAINED storage allocated for program stack use.

Field Name: QW0225GS

TOTAL STACK STORAGE IN USE (MB)

The amount of stack storage that is in use.

Field Name: QW0225SU

SYSTEM AGENT STACK STORAGE IN USE (MB)

The amount of 31-bit stack storage that is in use for system agents. This is a subset of QW0225SU.

Field Name: QW0225SS

STORAGE CUSHION (MB)

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.

Field Name: STORCUSH

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.

Field Name: QW0225LO

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 authorized programs.

Field Name: QW0225HI

24 BIT PRIVATE CURRENT HIGH ADDRESS

The current high address of the 24-bit private region.

Field Name: QW0225TP

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.

Field Name: QW0225EL

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.

Field Name: QW0225EH

31 BIT PRIVATE CURRENT HIGH ADDRESS

The current high address of the 31-bit private region.

Field Name: QW0225EP

EXTENDED REGION SIZE (MAX) (MB)

The maximum amount of MVS private storage available above the 16 MB line.

Field Name: QW0225RG

Feedback