SAP ABAP Table DB2_VIEW_IFI225 (view structure for performance - virtual / real storage)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	INTTAB	Structure
Structure	DB2_VIEW_IFI225	Table Relationship Diagram
Short Description	view structure for performance - virtual / real storage

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

History

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