SAP ABAP Table DB2QW0225_V10 (DB2 IFCID 225 - DBM1 virtual storage monitoring)

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	DB2QW0225_V10	Table Relationship Diagram
Short Description	DB2 IFCID 225 - DBM1 virtual storage monitoring

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

History

Last changed by/on	SAP	20141013
SAP Release Created in