SAP ABAP Data Element DB2CCPSEUD (REORG Index: Pseudo deletes 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
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 | DB2CCPSEUD |
| Short Description | REORG Index: Pseudo deletes 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 | Pseudo del |
| Medium | 15 | Pseudo deletes |
| Long | 25 | Pseudo deletes in percent |
| Heading | 25 | Pseudo deletes 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 REORG on a 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 ratio of the number of index entries that were pseudo-deleted since the last REORG, REBUILD INDEX, or LOAD REPLACE to the number of index entries in the index space or partition, expressed as a percentage. The default is 10.
- When displayed as output, the value is the ratio of the number of index entries that were pseudo-deleted since the last REORG, REBUILD INDEX, or LOAD REPLACE to the 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. Otherwise, this value is null.
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 620 |
