SAP ABAP Data Element DB2CCSCHGS (RUNSTATS TS/IX: Changed rows in percent)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390
Basic Data
Data Element DB2CCSCHGS
Short Description RUNSTATS TS/IX: Changed rows in percent  
Data Type
Category of Dictionary Type     Direct Type Entry
Type of Object Referenced     No Information
Domain / Name of Reference Type      
Data Type INT4   4-byte integer, integer number with sign 
Length 10    
Decimal Places 0    
Output Length 11    
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 10 Chgd. rows 
Medium 20 RUNST.: Changed rows 
Long 33 RUNSTATS: Changed rows in percent 
Heading 33 RUNSTATS: Changed rows in percent 
Documentation

Definition

Beginning with DB2 V7.1, SAP utilizes a stored procedure named DSNACCOR which recommends running a utility based upon data in the real-time statistic tables. The recommendation for updating statistics of a table- or indexspace by running RUNSTATS is based on a complex calculation, which is detailed in DB2 UDB for OS/390 and z/OS V7 Utility Guide and Reference. This is one of the values that is used in the calculation.

It is an input and output parameter of type INTEGER:

  • When used for input:
    • The value acts as threshold for the ratio of the number INSERTs, UPDATEs, and DELETEs since the last RUNSTATS on a table space or partition, to the total number of rows or LOBs in the table space or partition, expressed as a percentage, in case the object is a tablespace.
    • The value acts as threshold for the ratio of the number inserted and deleted index entries since the last RUNSTATS on an index space or partition, to the total number of index entries in the index space or partition, expressed as a percentage, in case the object is an indexspace.
    • The default is 20.
  • When displayed as output, the value is:
    • The ratio of the number INSERTs, UPDATEs, and DELETEs since the last RUNSTATS on a table space or partition, to the total number of rows or LOBs in the table space or partition, expressed as a percentage, if object is tablespace and there's a recommendation for RUNSTATS.
    • The ratio of the number INSERTs and DELETEs since the last RUNSTATS on the index space or partition, to the total number of index entries in the index space or partition, expressed as a percentage, if object is indexspace and there's a recommendation for RUNSTATS.
    • NULL in any other case.

History
Last changed by/on SAP  20130604 
SAP Release Created in 620