SAP ABAP Data Element DB2GHITRAT (Dynamic Statement Cache Global Hit Ratio)

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

Data Element	DB2GHITRAT
Short Description	Dynamic Statement Cache Global Hit Ratio

Data Type

Category of Dictionary Type		Direct Type Entry
Type of Object Referenced		No Information
Domain / Name of Reference Type
Data Type	CHAR	Character String
Length	7
Decimal Places	0
Output Length	7
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	0
Medium	20	Stmts.cache_gl.hit
Long	29	Stmts. cache global hit ratio
Heading	0

Documentation

Definition

The global hit ratio is defined as

100 * (QISEDSG - QISEDSI) / QISEDSG

where:
QISEDSG:    Number of requests for the dynamic statement cache
QISEDSI:    Number of inserts into the dynamic statement cache

History

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