SAP ABAP Data Element DB2CCRCHGS (REORG 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 DB2CCRCHGS
Short Description REORG 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 19 REORG: Changed rows 
Long 30 REORG: Changed rows in percent 
Heading 30 REORG: 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 a REORG on a table- or indexspace 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:
    • If the ratio of the sum of INSERTs, UPDATEs, and DELETEs since the last REORG to the total number of rows or LOBs in the table space or partition, expressed as a percentage, is greater than this value, DSNACCOR recommends running REORG on the tablespace.
    • If the ratio of the sum of the number of index entries that were inserted and deleted since the last REORG to the total number of index entries in the index space or partition, expressed as a percentage, is greater than this value, DSNACCOR recommends running REORG on the indexspace.
    • The default is 20.
  • When displayed as output, the value is:
    • The ratio of the sum of INSERTs, UPDATEs, and DELETEs since the last REORG 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 REORG.
    • The ratio of the sum of INSERTs and DELETEs since the last REORG 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 REORG.
    • NULL in any other case.

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