SAP ABAP Data Element DB2WP4NPAG (NPAGES threshold for index scan)
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 DB2WP4NPAG
Short Description NPAGES threshold for index scan  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type DB2INT4U    
Data Type INT4   4-byte integer, integer number with sign 
Length 10    
Decimal Places 0    
Output Length 10    
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 16 NPAGES threshold 
Long 31 NPAGES threshold for index scan 
Heading  
Documentation

Definition

The value is input to the access path selection process. Should NPAGES for a given table be less than the value, an index access will be preferred over tablespace scan.

ZPARM name: NPGTHRSH in DSN6SPRM.

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