SAP ABAP Data Element DB2CCRMASS (REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.))
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 | DB2CCRMASS |
Short Description | REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) |
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 | R mass del |
Medium | 20 | REORG: Mass deletion |
Long | 36 | REORG: Mass deletes resp table drops |
Heading | 40 | REORG: Mass deletes resp table drops |
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 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:
- The value acts as threshold for the number of mass deletes from a segmented or LOB table space since the last REORG or LOAD REPLACE respectively the number of dropped tables from a nonsegmented table space since the last REORG or LOAD REPLACE, in case the object is a tablespace.
- For an indexspace, if the number of mass deletes from an index space or partition since the last REORG, REBUILD, or LOAD REPLACE is greater than this value, DSNACCOR recommends running REORG.
- The default is 0.
- When displayed as output, the value is:
- The number of mass deletes since the last REORG or LOAD REPLACE, if object is a segmented tablespace and there's a recommendation for REORG.
- The number of dropped tables since the last REORG or LOAD REPLACE, if object is a nonsegmented tablespace and there's a recommendation for REORG.
- The number of mass deletes from the index space or partition since the last REORG, REBUILD, or LOAD REPLACE, 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 |