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