Hierarchy
DMIS (Software Component) DMIS 2011_1⤷
CA-EUR (Application Component) European Monetary Union: Euro⤷
CNV_INC_PROCESSING (Package) incremental processing using DB triggers and logging tables
Basic Data
| Data Element | IUUC_DATA_LOGTAB |
| Short Description | data fields in logging table |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | BOOLEAN | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| 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 | data logtb |
| Medium | 15 | data in logtab |
| Long | 20 | data in logging tb |
| Heading | 15 | data in logtab |
Documentation
Definition
If the incremental upgrade is done in the mode "restricted incrementality", it is possible to determine that the data fields of the corresponding original table should also be included in the logging table. In this case, it is not required to re-read the data from the original table during the delta replay, which will result in a better performance of the delta replay.
However, this option is not possible if the database system is DB6, and if the "buffered insert" feature is active (it is active by default). So if the data fields should be part of the logging tables, and the re-reading of the data from the original tables should be avoided also in case DB6 is used as DB system, you need to proceed as follows (this change is mandatory as you otherwise run the risk to transfer inconsistent data):
Îf the system runs with 6.40 kernel release, the feature must be deactivated in db2cli.ini . In the [COMMON] section of db2cli.ini, you need to enter: InsertBuffering=-1
If the system runs with 7.00 kernel release, buffered insert is only active in case the database has multiple partitions. If you need to deactivate this, you can either set environment variable
DB6_DBSL_INSERT_BUFFERING=0
or you set profile parameter
dbs/db6/dbsl_insert_buffering=0
History
| Last changed by/on | SAP | 20141029 |
| SAP Release Created in | 2006_1_620 |
