SAP ABAP Data Element DB2CCCCHGS (Full/Inc. Copy: 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 DB2CCCCHGS
Short Description Full/Inc. Copy: 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 16 Changed rows [%] 
Long 23 Changed rows in percent 
Heading 16 Changes rows [%] 
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 a full or incremental image copy 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 image copy to the total number of rows or LOBs in a table space or partition, expressed as a percentage, in case the object is a tablespace.
    • For an indexspace, if the ratio of the number INSERTs and DELETEs since the last image copy to the total number of entries in the indexspace or partition, expressed as a percentage, is greater than this value, and the number of active pages in the index space or partition is greater than FCIndexSiz, DSNACCOR recommends an image copy.
    • The default is 10 for recommendation of full image copy and 1 for incremental image copy.
  • When displayed as output, the value is:
    • The ratio of the number INSERTs, UPDATEs, and DELETEs since the last image copy 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 a full or incremental image copy.
    • The ratio of the number INSERTs and DELETEs since the last image copy to the total number of entries in the index space or partition, expressed as a percentage, if object is indexspace and there's a recommendation for a full or incremental image copy.
    • NULL in any other case.

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