SAP ABAP Table DB2QW0225 (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	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	STRGVBP	☐			INT4	10	0
8	STRGEDM	☐			INT4	10	0
9	STRGCAST	☐			INT4	10	0
10	STRGVPCB	☐			INT4	10	0
11	STRGDSCB	☐			INT4	10	0
12	STRGHPCB	☐			INT4	10	0
13	STRGCUSH	☐			INT4	10	0
14	STRGTHRD	☐			INT4	10	0
15	STRGTHST	☐			INT4	10	0
16	STRGDBM1	☐			INT4	10	0
17	STRGDSLA	☐			INT4	10	0
18	STRGAVAI	☐			INT4	10	0
19	AVGTHREAD	☐			INT4	10	0
20	.INCLUDE	☐				0	0	IFCID 0225 shows usage of virtual storage of DBM1
21	QW0225AL	☐	DB2W225AL	DB2INT4	INT4	10	0	TOTAL AGENT LOCAL POOL STORAGE
22	QW0225AS	☐	DB2W225AS	DB2INT4	INT4	10	0	TOTAL AGENT SYSTEM STORAGE
23	QW0225AV	☐	DB2W225AV	DB2INT4	INT4	10	0	AMOUNT OF AVAILABLE STORAGE
24	QW0225CD	☐	DB2W225CD	DB2DEC19V	DEC	19	0	TOTAL STORAGE FOR COMPRESSION DICTIONARY
25	QW0225CR	☐	DB2W225CR	DB2INT4	INT4	10	0	TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS
26	QW0225FX	☐	DB2W225FX	DB2INT4	INT4	10	0	TOTAL FIXED STORAGE
27	QW0225GM	☐	DB2W225GM	DB2INT4	INT4	10	0	TOTAL GETMAINED STORAGE
28	QW0225GS	☐	DB2W225GS	DB2INT4	INT4	10	0	TOTAL GETMAINED STACK STORAGE
29	QW0225MV	☐	DB2W225MV	DB2INT4	INT4	10	0	TOTAL AMOUNT OF STORAGE FOR MVS USE
30	QW0225PM	☐	DB2W225PM	DB2INT4	INT4	10	0	TOTAL STORAGE FOR PIPE MANAGER SUBPOOL
31	QW0225RO	☐	DB2W225RO	DB2INT4	INT4	10	0	TOTAL STORAGE FOR RDS OP POOL
32	QW0225RP	☐	DB2W225RP	DB2DEC19V	DEC	19	0	TOTAL STORAGE FOR RID POOL
33	QW0225SB	☐	DB2W225SB	DB2INT4	INT4	10	0	TOTAL STORAGE FOR STATEMENT CACHE BLOCK
34	QW0225SC	☐	DB2W225SC	DB2INT4	INT4	10	0	TOTAL STORAGE FOR THREAD COPIES OF CACHED SQL STATEMENTS
35	QW0225SO	☐	DB2W225SO	DB2INT4	INT4	10	0	STORAGE CUSHION WARNING TO CONTRACT
36	QW0225TT	☐	DB2W225TT	DB2INT4	INT4	10	0	TOT. STOR. BUFFER MANAGER OR DATA MANAGER INT. TRACE TABLE
37	QW0225VR	☐	DB2W225VR	DB2INT4	INT4	10	0	TOTAL VARIABLE STORAGE
38	QW0225AT	☐	DB2W225AT	DB2INT4	INT4	10	0	NUMBER OF ACTIVE ALLIED THREADS
39	QW0225CE	☐	DB2W225CE	DB2INT4	INT4	10	0	NUMBER OF CASTOUT ENGINES
40	QW0225DW	☐	DB2W225DW	DB2INT4	INT4	10	0	NUMBER OF DEFERRED WRITE ENGINES
41	QW0225GW	☐	DB2W225GW	DB2INT4	INT4	10	0	NUMBER OF GBP WRITE ENGINES
42	QW0225PF	☐	DB2W225PF	DB2INT4	INT4	10	0	NUMBER OF PREFETCH ENGINES
43	QW0225PL	☐	DB2W225PL	DB2INT4	INT4	10	0	NUMBER OF P-LOCK/NOTIFY EXIT ENGINES
44	QW0225SJ	☐			INT4	10	0
45	QW0225LO	☐			INT4	10	0
46	QW0225HI	☐			INT4	10	0
47	QW0225EL	☐			INT4	10	0
48	QW0225EH	☐			INT4	10	0
49	QW0225RG	☐			INT4	10	0
50	QW0225EC	☐			INT4	10	0
51	QW0225FA	☐	DB2W225FA	DB2DEC19V	DEC	19	0	private fixed pool storage
52	QW0225GA	☐	DB2W225GA	DB2DEC19V	DEC	19	0	private getmained storage
53	QW0225VA	☐	DB2W225VA	DB2DEC19V	DEC	19	0	private variable pool storage
54	QW0225LC	☐			INT4	10	0
55	QW0225LS	☐			INT4	10	0
56	QW0225HS	☐			INT4	10	0
57	QW0225HC	☐			INT4	10	0
58	HWDSCDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
59	HWDSCTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
60	HWDSCMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
61	QW0225RL	☐	DB2W225RL	DB2DEC19V	DEC	19	0	Number of real frames (4K) in use
62	QW0225AX	☐	DB2W225AX	DB2DEC19V	DEC	19	0	Number of auxiliary slots (4k) in use
63	QW0225SF	☐	DB2W225SF	DB2DEC19V	DEC	19	0	Total fixed shared 64-bit storage
64	QW0225SG	☐	DB2W225SG	DB2DEC19V	DEC	19	0	Total GETMAINed shared 64-bit storage
65	QW0225SV	☐	DB2W225SV	DB2DEC19V	DEC	19	0	Total variable shared 64-bit storage
66	QW0225SU	☐	DB2W225SU	DB2DEC19V	DEC	19	0	Total 31-bit stack storage in use
67	QW0225L2	☐	DB2W225L2	DB2DEC19V	DEC	19	0	Allocated statement cache storage in 64-bit agent local pool
68	QW0225H2	☐	DB2W225H2	DB2DEC19V	DEC	19	0	High water mark for alloc. stmt cache storage in 64-bit pool
69	QW0225S2	☐	DB2W225S2	DB2DEC19V	DEC	19	0	Total 64-bit STMT CACHE BLOCKS 2G storage

History

Last changed by/on	SAP	20110908
SAP Release Created in	620