SAP ABAP Data Element DB2RPRERAT (Reprepare 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 DB2RPRERAT
Short Description Reprepare 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  
Medium 15 Reprepare ratio 
Long 20 Reprepare ratio 
Heading  
Documentation

Definition

The reprepare ratio is defined as

100 * QXSTIPRP / QXSTDEXP

where:
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.

QXSTDEXP:
The number of times that DB2 discarded a prepared statement from the prepared statement cache because the number of prepared statements in the cache exceeded the value of the subsystem parameter MAXKEEPD.

History
Last changed by/on SAP  20110908 
SAP Release Created in 710