DBM1 Storage Above 2 GB
This topic shows detailed information about Statistics - DBM1 Storage Above 2 GB
.
Statistics - DBM1 Storage Above 2 GB
The field labels shown in the following sample layout of Statistics - DBM1 Storage Above 2 GB
are described in the following section.
DBM1 STORAGE ABOVE 2 GB QUANTITY
-------------------------------------------- ------------------
GETMAINED STORAGE (MB) 411.40
COMPRESSION DICTIONARY (MB) 0.00
IN USE EDM DBD POOL (MB) N/A
IN USE EDM STATEMENT POOL (MB) N/A
IN USE EDM SKELETON POOL (MB) N/A
FIXED STORAGE POOL (MB) 7.65
VARIABLE STORAGE POOL (MB) 30.68
IN USE EDM DBD POOL (MB) 1.28
IN USE EDM STATEMENT POOL (MB) 13.02
IN USE EDM SKELETON POOL (MB) 1.05
STORAGE MANAGER CONTROL BLOCKS (MB) 6.71
VIRTUAL BUFFER POOLS (MB) 1244.62
VIRTUAL POOL CONTROL BLOCKS (MB) 12.67
CASTOUT BUFFERS (MB) 0.00
SHARED GETMAINED STORAGE (MB) 33.45
STORAGE FOR STMT DEPENDENCIES (MB) 29.35
SHARED FIXED STORAGE (MB) 3.57
RID POOL (MB) 1.00
SHARED VARIABLE STORAGE (MB) 95.11
TOTAL AGENT LOCAL STORAGE (MB) 84.71
TOTAL AGENT SYSTEM STORAGE (MB) 7.50
TOTAL AGENT NON-SYSTEM STORAGE (MB) 77.21
THREAD COPIES OF CACHED SQL STMTS (MB) N/A
IN USE STORAGE (MB) 0.11
STATEMENTS COUNT 9.57
HWM FOR ALLOCATED STATEMENTS (MB) 0.59
STATEMENT COUNT AT HWM 24.00
DATE AT HWM 02/27/14
TIME AT HWM 13:15:30.39
DYNAMIC STMT CACHE CNTL BLKS (MB) 1.18
SYSTEM COPIES OF CACHED SQL STMTS (MB) N/A
IN USE STORAGE (MB) N/A
HWM FOR ALLOCATED STATEMENTS (MB) N/A
SYSTEM COPIES OF STATIC SQL (MB) N/A
IN USE STORAGE (MB) N/A
THREAD PLAN AND PACKAGE STORAGE (MB) 0.59
ARRAY VARIABLE STORAGE (MB) N/A
SHARED STORAGE MANAGER CNTL BLKS (MB) 3.09
SHARED SYSTEM AGENT STACK STORAGE (MB) 256.00
STACK STORAGE IN USE (MB) 41.97
SHARED NON-SYSTEM AGENT STACK STORAGE (MB) 768.00
STACK STORAGE IN USE (MB) 8.47
- GETMAINED STORAGE (MB)
-
Total storage acquired by GETMAIN. 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.
Field Name: QW0225GA
- COMPRESSION DICTIONARY (MB)
-
Storage space allocated for the compression dictionary.
Field Name: QW0225CD
- IN USE EDM DBD POOL (MB)
-
The amount of storage used by database descriptors in the EDM DBD pool above the 2 GB bar.
Field Name: SISEDBDP
- IN USE EDM STATEMENT POOL (MB)
-
The amount of storage used by cached dynamic SQL statements in the EDM Statement pool above the 2 GB bar.
Field Name: SISEDYNP
- IN USE EDM SKELETON POOL (MB)
-
The amount of storage used by objects in the EDM Skeleton pool above the 2 GB bar.
Field Name: SISESKCP
- FIXED STORAGE POOL (MB)
-
The total amount of fixed storage above the 2 GB bar.
Field Name: QW0225FA
- VARIABLE STORAGE POOL (MB)
-
Amount of variable storage available above the 2 GB bar.
Field Name: QW0225VA
- IN USE EDM DBD POOL (MB)
-
The amount of storage used by database descriptors in the EDM DBD pool above the 2 GB bar.
Field Name: SISEDBDP
- IN USE EDM STATEMENT POOL (MB)
-
The amount of storage used by cached dynamic SQL statements in the EDM Statement pool above the 2 GB bar.
Field Name: SISEDYNP
- IN USE EDM SKELETON POOL (MB)
-
The amount of storage used by objects in the EDM Skeleton pool above the 2 GB bar.
Field Name: SISESKCP
- STORAGE MANAGER CONTROL BLOCKS (MB)
-
Total 64-bit storage allocated for storage manager control structures.
Field Name: QW0225SM
- VIRTUAL BUFFER POOLS (MB)
-
Total storage allocated for virtual buffer pools above the 2 GB bar.
Field Name: SVPOOLZ
- VIRTUAL POOL CONTROL BLOCKS (MB)
-
Storage used for primary virtual pool control blocks above the 2 GB bar.
Field Name: SBSTVPLZ
- CASTOUT BUFFERS (MB)
-
Storage used for castout buffers.
Field Name: SW0225C2
- SHARED GETMAINED STORAGE (MB)
-
The amount of virtual shared storage acquired by GETMAIN above the 2 GB bar.
Field Name: QW0225SG
- STORAGE FOR STMT DEPENDENCIES (MB)
-
The amount of storage allocated above the 2 GB bar to support object dependencies on statements that are in the Dynamic Statement Cache (Db2 field: QW0225DMH).
Field Name: SW225DMH
- SHARED FIXED STORAGE (MB)
-
The amount of total fixed virtual shared storage above the 2 GB bar.
Field Name: QW0225SF
- RID POOL (MB)
-
Storage for RID list processing such as list prefetch, index ANDing, and ORing.
Field Name: QW0225RP
- SHARED VARIABLE STORAGE (MB)
-
The amount of virtual shared variable storage above the 2 GB bar.
Field Name: QW0225SV
- TOTAL AGENT LOCAL STORAGE (MB)
-
The amount of storage allocated for agent-related 64-bit local storage (Db2 field: QW0225ALG).
Field Name: SW225ALG
- TOTAL AGENT SYSTEM STORAGE (MB)
-
The amount of 64-bit storage used by system agents (Db2 field: QW0225ASG).
Field Name: SW225ASG
- TOTAL AGENT NON-SYSTEM STORAGE (MB)
-
The amount of 64-bit storage used by non-system agents. It is the difference between the Total Agent Local Storage (QW0225ALG) and the Total Agent System Storage (QW0225ASG).
Field Name: SW225ANG
- THREAD COPIES OF CACHED SQL STMTS (MB)
-
This field is provided for consistency purposes. It has a value of N/A. The value can be estimated by the HWM FOR ALLOCATED STATEMENTS (QW0225H2).
Field Name: SW0225DY
- IN USE STORAGE (MB)
-
The total non-shareable storage requested for dynamic SQL statements used by active threads. This value is related to shared agent local variable pools above the bar.
Field Name: QW0225L2
- STATEMENTS COUNT
-
The number of dynamic SQL local cache statements used by active threads. This value is related to shared agent local variable pools above the bar.
Field Name: QW0225LC
- HWM FOR ALLOCATED STATEMENTS (MB)
-
This value is related to shared agent local variable pools above the bar.
Field Name: QW0225H2
- STATEMENT COUNT AT HWM
-
The number of dynamic SQL local cache statements used by active threads at high storage time. This value is related to shared agent local variable pools above the bar.
Field Name: QW0225HC
- DATE AT HWM
-
The timestamp at high-water storage.
Field Name: QW0225HT
- TIME AT HWM
-
The timestamp at high-water storage.
Field Name: QW0225HT
- DYNAMIC STMT CACHE CNTL BLKS (MB)
-
The total statement cache storage blocks above the bar (64-bit shared variable pool).
Field Name: QW0225S2
- SYSTEM COPIES OF CACHED SQL STMTS (MB)
-
The total shareable storage allocated for dynamic SQL statements used by active threads.
- For Db2 11, this field is derived from QW0225SC8 and related to storage above the bar.
- Prior to Db2 11, this field is derived from QW0225SC and related to storage below the bar. The storage is used for executable code sequences (xPROC).
Field Name: SW0225SC
- IN USE STORAGE (MB)
-
The total shareable storage requested for dynamic SQL statements used by active threads.
- For Db2 11, this field is derived from QW0225LS8 and related to storage above the bar.
- Prior to Db2 11, this field is derived from QW0225LS and related to storage below the bar. The storage is used for executable code sequences (xPROC).
Field Name: SW0225LS
- HWM FOR ALLOCATED STATEMENTS (MB)
-
A statistics interval high-water mark of requested shareable storage for dynamic SQL statements used by active threads.
- For Db2 11, this field is derived from QW0225HS8 and related to storage above the bar.
- Prior to Db2 11, this field is derived from QW0225HS and related to storage below the bar. The storage is used for executable code sequences (xPROC).
Field Name: SW0225HS
- SYSTEM COPIES OF STATIC SQL (MB)
-
The total shareable storage allocated for static SQL statements.
- For Db2 11, this field is derived from QW0225SX8 and related to storage above the bar.
- Prior to Db2 11, this field is derived from QW0225SX and used for storage of executable code sequences (xPROC) below the bar.
Field Name: SW0225SX
- IN USE STORAGE (MB)
-
The total storage requested for shareable static SQL statements.
- For Db2 11, this field is derived from QISEKSPA and related to storage above the bar.
- Prior to Db2 11, this field is derived from QISEKSPA8 and used for storage of executable code sequences (xPROC) below the bar.
Field Name: SISEKSPA
- THREAD PLAN AND PACKAGE STORAGE (MB)
-
The storage allocated to plans and packages above the bar.
Field Name: SISESQA
- ARRAY VARIABLE STORAGE
-
The amount of storage in use for array variables.
Field Name: QW0225AR
- SHARED STORAGE MANAGER CNTL BLKS (MB)
-
The amount of 64-bit shared storage allocated for storage manager control structures (Db2 field: QW0225SMS).
Field Name: SW225SMS
- SHARED SYSTEM AGENT STACK STORAGE (MB)
-
The amount of 64-bit shared storage allocated for system agent stack use (Db2 field: QW0225GSG_SYS).
Field Name: SW225GSY
- STACK STORAGE IN USE (MB)
-
The amount of 64-bit shared system agent stack that is in use (Db2 field: QW0225SUG_SYS).
Field Name: SW225SSY
- SHARED NON-SYSTEM AGENT STACK STORAGE (MB)
-
The amount of 64-bit shared storage allocated for non-system agent stack use (Db2 field: QW0225GSG).
Field Name: SW225GSG
- STACK STORAGE IN USE (MB)
-
The amount of 64-bit shared non-system agent stack that is in use (Db2 field: QW0225SUG).
Field Name: SW225SUG