SAP ABAP Data Element DB2LHITRAT (Dynamic Statement Cache Local 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	DB2LHITRAT
Short Description	Dynamic Statement Cache Local 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	15	Local hit ratio
Long	28	Stmts. cache local hit ratio
Heading	0

Documentation

Definition

The local hit ratio is defined as

100 * QXSTNPRP / (QXSTNPRP + QXSTIPRP)

where:
QXSTNPRP:
The number of times that DB2 did not prepare a statement bound with KEEPDYNAMIC(YES) because the prepared statement cache contained a valid copy of the prepared statement.

QXSTIPRP:
The number of times that DB2 did an implicit prepare for a statement bound with KEEPDYNAMIC(YES) because the prepared statement cache did not contain a valid copy of the prepared statement.

History

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