SAP ABAP Table DB2QW0254 (Statistics CF Cache Structure Data)

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	DB2QW0254	Table Relationship Diagram
Short Description	Statistics CF Cache Structure Data

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	QW0254GN	☐	DB2W0254GN	DB2NUMC10	NUMC	10	0	The name of the group buffer pool
2	QW0254RH	☐	DB2W0254RH	DB2NUMC10	NUMC	10	0	Read hit
3	QW0254RD	☐	DB2W0254RD	DB2NUMC10	NUMC	10	0	Read-miss directory-hit counter
4	QW0254RS	☐	DB2W0254RS	DB2NUMC10	NUMC	10	0	Read-miss assignment-suppressed
5	QW0254RN	☐	DB2W0254RN	DB2NUMC10	NUMC	10	0	Read-miss name-assigned
6	QW0254RF	☐	DB2W0254RF	DB2NUMC10	NUMC	10	0	Read-miss cache-full
7	QW0254WH	☐	DB2W0254WH	DB2NUMC10	NUMC	10	0	Changed page write-hit
8	QW0254WC	☐	DB2W0254WC	DB2NUMC10	NUMC	10	0	Clean page write-hit
9	QW0254WF	☐	DB2W0254WF	DB2NUMC10	NUMC	10	0	Write-miss cache-full
10	QW0254DR	☐	DB2W0254DR	DB2NUMC10	NUMC	10	0	Directory entry reclaims
11	QW0254TR	☐	DB2W0254TR	DB2NUMC10	NUMC	10	0	Data entry reclaims
12	QW0254XR	☐	DB2W0254XR	DB2NUMC10	NUMC	10	0	Directory entry reclaims with XI
13	QW0254CC	☐	DB2W0254CC	DB2NUMC10	NUMC	10	0	The number of castout operations performed.
14	QW0254DE	☐	DB2W0254DE	DB2NUMC10	NUMC	10	0	The number of allocated directory entries (not cumulative).
15	QW0254TE	☐	DB2W0254TE	DB2NUMC10	NUMC	10	0	# of allocated data entries (snapshot, not cumulative)
16	QW0254TC	☐	DB2W0254TC	DB2NUMC10	NUMC	10	0	Changed pages
17	QW0254GC	☐	DB2W0254GC	DB2CHAR08	CHAR	8	0	Group buffer pool name
18	QW02542W	☐	DB2W02542W	DB2NUMC10	NUMC	10	0	Secondary group buffer pool: Changed page write-hit
19	QW02542F	☐	DB2W02542F	DB2NUMC10	NUMC	10	0	Secondary group buffer pool: Write-miss cache-full
20	QW02542D	☐	DB2W02542D	DB2NUMC10	NUMC	10	0	Secondary group buffer pool: Directory entries allocated
21	QW02542T	☐	DB2W02542T	DB2NUMC10	NUMC	10	0	Secondary group buffer pool: Data entries allocated
22	QW02542C	☐	DB2W02542C	DB2NUMC10	NUMC	10	0	Secondary group buffer pool: Changed pages
23	QW0254CI	☐	DB2W0254CI	DB2NUMC10	NUMC	10	0	Explicit cross invalidations

History

Last changed by/on	SAP	20070813
SAP Release Created in	710