SAP ABAP Data Element DB2CGHITRA (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	DB2CGHITRA
Short Description	Dynamic Statement Cache Global Hit Ratio

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	DB2DEC5_2
Data Type	DEC	Counter or amount field with comma and sign
Length	5
Decimal Places	2
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	16	Global hit ratio
Long	20	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	20070813
SAP Release Created in	710