SAP ABAP Data Element DB2CCCHGA (RUN.:Changed rows (insert, delete or update) absolute number)
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 DB2CCCHGA
Short Description RUN.:Changed rows (insert, delete or update) absolute number  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type FLTP    
Data Type FLTP   Floating point number, accurate to 8 bytes 
Length 16    
Decimal Places 16    
Output Length 22    
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 15 Changed rows 
Long 28 Changed rows absolute number 
Heading 28 Changed rows absolute number 
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 number of INSERTs, UPDATEs, and DELETEs since the last RUNSTATS on a table space or partition, in case the object is a tablespace.
    • The value acts as threshold for the number of INSERTs and DELETEs since the last RUNSTATS on the index space or partition, in case the object is an indexspace.
    • The default is 50.
  • When displayed as output, the value is:
    • The number of INSERTs, UPDATEs, and DELETEs since the last RUNSTATS on a table space or partition, if object is tablespace and there's a recommendation for RUNSTATS.
    • The number of INSERTs and DELETEs since the last RUNSTATS on the index space or partition, if object is indexspace and there's a recommendation for RUNSTATS.
    • NULL in any other case.

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