SAP ABAP Table DB2QW225_V10 (IFCID 0225 shows usage of virtual storage of DBM1)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QW225_V10	Table Relationship Diagram
Short Description	IFCID 0225 shows usage of virtual storage of DBM1

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DIST_QW0225RG	☐			INT4	10	0
2	DIST_QW0225LO	☐			INT4	10	0
3	DIST_QW0225HI	☐			INT4	10	0
4	DIST_QW0225EL	☐			INT4	10	0
5	DIST_QW0225EH	☐			INT4	10	0
6	DIST_QW0225TP	☐			CHAR	10	0
7	DIST_QW0225EP	☐			CHAR	10	0
8	DIST_QW0225CR	☐	DB2W225CR	DB2INT4	INT4	10	0	TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS
9	DIST_QW0225MV	☐	DB2W225MV	DB2INT4	INT4	10	0	TOTAL AMOUNT OF STORAGE FOR MVS USE
10	DIST_QW0225SO	☐	DB2W225SO	DB2INT4	INT4	10	0	STORAGE CUSHION WARNING TO CONTRACT
11	DIST_QW0225GS	☐	DB2W225GS	DB2INT4	INT4	10	0	TOTAL GETMAINED STACK STORAGE
12	DIST_QW0225SU	☐			INT4	10	0
13	DIST_QW0225VR	☐	DB2W225VR	DB2INT4	INT4	10	0	TOTAL VARIABLE STORAGE
14	DIST_QW0225FX	☐	DB2W225FX	DB2INT4	INT4	10	0	TOTAL FIXED STORAGE
15	DIST_QW0225GM	☐	DB2W225GM	DB2INT4	INT4	10	0	TOTAL GETMAINED STORAGE
16	DIST_QW0225AV	☐	DB2W225AV	DB2INT4	INT4	10	0	AMOUNT OF AVAILABLE STORAGE
17	DIST_QW0225VA	☐	DB2W225VA	DB2DEC19V	DEC	19	0	private variable pool storage
18	DIST_QW0225FA	☐	DB2W225FA	DB2DEC19V	DEC	19	0	private fixed pool storage
19	DIST_QW0225GA	☐	DB2W225GA	DB2DEC19V	DEC	19	0	private getmained storage
20	DIST_QW0225SM	☐	DB2W225SM	DB2DEC19V	DEC	19	0	Total 64-bit private storage f. stor. manager control struct
21	DIST_QW0225RL	☐	DB2W225RL	DB2DEC19V	DEC	19	0	Number of real frames (4K) in use
22	DIST_QW0225AX	☐	DB2W225AX	DB2DEC19V	DEC	19	0	Number of auxiliary slots (4k) in use
23	DIST_QW0225HV_PAGES_IN_REAL	☐	DB2W225HV_PAGES_IN_REAL	DB2DEC19V	DEC	19	0	Number of real 4K frames in use for 64-bit private
24	DIST_QW0225HV_AUX_SLOTS	☐	DB2W225HV_AUX_SLOTS	DB2DEC19V	DEC	19	0	Number of 4K auxiliary slots in use for 64-bit private
25	DIST_QW0225HVG_PAGES_IN_REAL	☐	DB2W225HVG_PAGES_IN_REAL	DB2DEC19V	DEC	19	0	High water mark for # of real 4K frames in use for 64-bit
26	DIST_QW0225HVG_AUX_SLOTS	☐	DB2W225HVG_AUX_SLOTS	DB2DEC19V	DEC	19	0	High water mark for 4K aux. slots in use for 64-bit private
27	DBM1_QW0225RG	☐			INT4	10	0
28	DBM1_QW0225LO	☐			INT4	10	0
29	DBM1_QW0225HI	☐			INT4	10	0
30	DBM1_QW0225EL	☐			INT4	10	0
31	DBM1_QW0225EH	☐			INT4	10	0
32	DBM1_QW0225TP	☐			CHAR	10	0
33	DBM1_QW0225EP	☐			CHAR	10	0
34	DBM1_QW0225CR	☐	DB2W225CR	DB2INT4	INT4	10	0	TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS
35	DBM1_QW0225MV	☐	DB2W225MV	DB2INT4	INT4	10	0	TOTAL AMOUNT OF STORAGE FOR MVS USE
36	DBM1_QW0225SO	☐	DB2W225SO	DB2INT4	INT4	10	0	STORAGE CUSHION WARNING TO CONTRACT
37	DBM1_QW0225GS	☐	DB2W225GS	DB2INT4	INT4	10	0	TOTAL GETMAINED STACK STORAGE
38	DBM1_QW0225SU	☐			INT4	10	0
39	DBM1_QW0225VR	☐	DB2W225VR	DB2INT4	INT4	10	0	TOTAL VARIABLE STORAGE
40	DBM1_QW0225FX	☐	DB2W225FX	DB2INT4	INT4	10	0	TOTAL FIXED STORAGE
41	DBM1_QW0225GM	☐	DB2W225GM	DB2INT4	INT4	10	0	TOTAL GETMAINED STORAGE
42	DBM1_QW0225AV	☐	DB2W225AV	DB2INT4	INT4	10	0	AMOUNT OF AVAILABLE STORAGE
43	DBM1_QW0225VA	☐	DB2W225VA	DB2DEC19V	DEC	19	0	private variable pool storage
44	DBM1_QW0225FA	☐	DB2W225FA	DB2DEC19V	DEC	19	0	private fixed pool storage
45	DBM1_QW0225GA	☐	DB2W225GA	DB2DEC19V	DEC	19	0	private getmained storage
46	DBM1_QW0225SM	☐	DB2W225SM	DB2DEC19V	DEC	19	0	Total 64-bit private storage f. stor. manager control struct
47	DBM1_QW0225RL	☐	DB2W225RL	DB2DEC19V	DEC	19	0	Number of real frames (4K) in use
48	DBM1_QW0225AX	☐	DB2W225AX	DB2DEC19V	DEC	19	0	Number of auxiliary slots (4k) in use
49	DBM1_QW0225HV_PAGES_IN_REAL	☐	DB2W225HV_PAGES_IN_REAL	DB2DEC19V	DEC	19	0	Number of real 4K frames in use for 64-bit private
50	DBM1_QW0225HV_AUX_SLOTS	☐	DB2W225HV_AUX_SLOTS	DB2DEC19V	DEC	19	0	Number of 4K auxiliary slots in use for 64-bit private
51	DBM1_QW0225HVG_PAGES_IN_REAL	☐	DB2W225HVG_PAGES_IN_REAL	DB2DEC19V	DEC	19	0	High water mark for # of real 4K frames in use for 64-bit
52	DBM1_QW0225HVG_AUX_SLOTS	☐	DB2W225HVG_AUX_SLOTS	DB2DEC19V	DEC	19	0	High water mark for 4K aux. slots in use for 64-bit private
53	QW0225AT	☐	DB2W225AT	DB2INT4	INT4	10	0	NUMBER OF ACTIVE ALLIED THREADS
54	QW0225DB	☐			INT4	10	0
55	QW0225CE	☐	DB2W225CE	DB2INT4	INT4	10	0	NUMBER OF CASTOUT ENGINES
56	QW0225DW	☐	DB2W225DW	DB2INT4	INT4	10	0	NUMBER OF DEFERRED WRITE ENGINES
57	QW0225GW	☐	DB2W225GW	DB2INT4	INT4	10	0	NUMBER OF GBP WRITE ENGINES
58	QW0225PF	☐	DB2W225PF	DB2INT4	INT4	10	0	NUMBER OF PREFETCH ENGINES
59	QW0225PL	☐	DB2W225PL	DB2INT4	INT4	10	0	NUMBER OF P-LOCK/NOTIFY EXIT ENGINES
60	QW0225EC	☐			INT4	10	0
61	QW0225FC	☐			INT4	10	0
62	QW0225VC	☐			INT4	10	0
63	QW0225GC	☐			INT4	10	0
64	QW0225FCG	☐	DB2W225FCG	DB2DEC19V	DEC	19	0	Total 64-bit common fixed pool storage
65	QW0225VCG	☐	DB2W225VCG	DB2DEC19V	DEC	19	0	Total 64-bit common variable pool storage
66	QW0225GCG	☐	DB2W225GCG	DB2DEC19V	DEC	19	0	Total 64-bit common getmained storage
67	QW0225SMC	☐	DB2W225SMC	DB2DEC19V	DEC	19	0	Total 64-bit common storage f.storage manager control struct
68	QW0225SF	☐	DB2W225SF	DB2DEC19V	DEC	19	0	Total fixed shared 64-bit storage
69	QW0225SG	☐	DB2W225SG	DB2DEC19V	DEC	19	0	Total GETMAINed shared 64-bit storage
70	QW0225SV	☐	DB2WQW0225SV	DB2DEC19V	DEC	19	0	Total 64-bit shared variable pool storage
71	QW0225SMS	☐	DB2W225SM	DB2DEC19V	DEC	19	0	Total 64-bit private storage f. stor. manager control struct
72	QW0225GSG_SYS	☐	DB2W225GSG_SYS	DB2DEC19V	DEC	19	0	Total 64-bit shared system agent stack
73	QW0225SUG_SYS	☐	DB2W225SUG_SYS	DB2DEC19V	DEC	19	0	Total 64-bit shared system agent stack in use
74	QW0225GSG	☐	DB2W225GSG	DB2DEC19V	DEC	19	0	Total 64-bit shared non-system agent stack
75	QW0225SUG	☐	DB2W225SUG	DB2DEC19V	DEC	19	0	Total 64-bit shared non-system agent stack in use
76	QW0225SHRNMOMB	☐			INT4	10	0
77	QW0225SHRPAGES	☐	DB2W225SHRPAGES	DB2DEC19V	DEC	19	0	# of 64-bit shared memory pages alloc. for this MVS LPAR
78	QW0225SHRGBYTES	☐	DB2W225SHRGBYTES	DB2DEC19V	DEC	19	0	High water mark for # of 64-bit shared bytes for this MVS L.
79	QW0225SHRINREAL	☐	DB2W225SHRINREAL	DB2DEC19V	DEC	19	0	# of 64-bit shared pages backed in real storage (4K pages)
80	QW0225SHRAUXSLOTS	☐	DB2W225SHRAUXSLOTS	DB2DEC19V	DEC	19	0	Number of auxiliary slots used for 64-bit shared storage
81	QW0225SHRPAGEINS	☐	DB2W225SHRPAGEINS	DB2DEC19V	DEC	19	0	Number of 64-bit shared pages paged in from aux. storage
82	QW0225SHRPAGEOUTS	☐	DB2W225SHRPAGEOUTS	DB2DEC19V	DEC	19	0	Number of 64-bit shared pages paged out to auxiliary storage
83	QW0225SC	☐			DEC	19	0
84	QW0225LC	☐			INT4	10	0
85	QW0225LS	☐			DEC	19	0
86	QW0225SX	☐			DEC	19	0
87	QW0225HS	☐			DEC	19	0
88	QW0225HC	☐			INT4	10	0
89	QW0225L2	☐	DB2W225L2	DB2DEC19V	DEC	19	0	Allocated statement cache storage in 64-bit agent local pool
90	QW0225H2	☐	DB2W225H2	DB2DEC19V	DEC	19	0	High water mark for alloc. stmt cache storage in 64-bit pool
91	QW0225S2	☐	DB2W225S2	DB2DEC19V	DEC	19	0	Total 64-bit STMT CACHE BLOCKS 2G storage
92	QW0225AL	☐	DB2W225AL	DB2INT4	INT4	10	0	TOTAL AGENT LOCAL POOL STORAGE
93	QW0225AS	☐	DB2W225AS	DB2INT4	INT4	10	0	TOTAL AGENT SYSTEM STORAGE
94	QW0225CD	☐	DB2W225CD	DB2DEC19V	DEC	19	0	TOTAL STORAGE FOR COMPRESSION DICTIONARY
95	QW0225ALG	☐	DB2W225ALG	DB2DEC19V	DEC	19	0	Total agent local storage (64-bit shared variable pools)
96	QW0225ASG	☐	DB2W225ASG	DB2DEC19V	DEC	19	0	Total system agent storage (64-bit shared variable pools)
97	QW0225BB	☐	DB2W225BB	DB2DEC19V	DEC	19	0	Total buffer manager storage blocks (31-bit DBM1)
98	QW0225RP	☐	DB2W225RP	DB2DEC19V	DEC	19	0	TOTAL STORAGE FOR RID POOL
99	DIST_QW0225SS	☐			INT4	10	0
100	DBM1_QW0225SS	☐			INT4	10	0
101	DBM1_QW0225PRI_STG_REAL	☐	DB2W225PRISTG_REAL	DB2DEC19V	DEC	19	0	# of real 4 K frames in use for 64-bit priv. storage
102	DBM1_QW0225PRI_STG_AUX	☐	DB2W225PRISTG_AUX	DB2DEC19V	DEC	19	0	# of real 4 K aux slots in use for 64-bit priv. storage
103	DIST_QW0225PRI_STG_REAL	☐	DB2W225PRISTG_REAL	DB2DEC19V	DEC	19	0	# of real 4 K frames in use for 64-bit priv. storage
104	DIST_QW0225PRI_STG_AUX	☐	DB2W225PRISTG_AUX	DB2DEC19V	DEC	19	0	# of real 4 K aux slots in use for 64-bit priv. storage
105	QW0225PT	☐			INT4	10	0
106	QW0225SHR_STG_REAL	☐	DB2W225SHRSTG_REAL	DB2DEC19V	DEC	19	0	# of real 4K frames in use for 64- bit shared storage
107	QW0225SHR_STG_AUX	☐	DB2W225SHRSTG_AUX	DB2DEC19V	DEC	19	0	# of real 4 K aux slots in use for 64- bit shared storage
108	QW0225SHR_STK_STG_REAL	☐	DB2W225SHRSTKSTG_REAL	DB2DEC19V	DEC	19	0	# of real 4K frames in use for 64- bit shared stack storage
109	QW0225SHR_STK_STG_AUX	☐	DB2W225SHRSTKSTG_AUX	DB2DEC19V	DEC	19	0	# of real 4K aux slots in use f 64- bit shared stack storage
110	QW0225COM_STG_REAL	☐	DB2W225COMSTG_REAL	DB2DEC19V	DEC	19	0	# of real 4K frames in use for 64- bit common storage
111	QW0225COM_STG_AUX	☐	DB2W225COMSTG_AUX	DB2DEC19V	DEC	19	0	# of real 4K aux slots in use for 64- bit common storage
112	REALSTORBP	☐	DB2REALSTORBP	DB2DEC19V	DEC	19	0	Real storage in use for 64-bit - used by DB2 buffer pools
113	AUXSTORBP	☐	DB2AUXSTORBP	DB2DEC19V	DEC	19	0	Aux. storage in use for 64-bit - used by DB2 buffer pools
114	QW0225SC8	☐			DEC	19	0
115	QW0225LS8	☐			DEC	19	0
116	QW0225SX8	☐			DEC	19	0
117	QW0225HS8	☐			DEC	19	0
118	QW0225_LMWRITE_REAL	☐			DEC	19	0
119	QW0225_LMCTRL_REAL	☐			DEC	19	0
120	QW0225_LMCTRL_AUX	☐			DEC	19	0
121	QW0225I_ABCSA	☐			DEC	19	0
122	QW0225I_ABCSH	☐			DEC	19	0
123	QW0225I_BBPVT	☐			DEC	19	0
124	QW0225I_BBPVH	☐			DEC	19	0
125	QW0225I_ABPVT	☐			DEC	19	0
126	QW0225I_ABPVH	☐			DEC	19	0
127	QW0225I_BBECSA	☐			DEC	19	0
128	QW0225I_BBECSAH	☐			DEC	19	0
129	QW0225I_BPMAX	☐			DEC	19	0
130	QW0225I_APMAX	☐			DEC	19	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	740