IUUC_PERF_OPTION - table-specific options for performance improvements
table-specific options for performance improvements information is stored in SAP table IUUC_PERF_OPTION.
It is part of development package CNV_IUUC_MAIN in software component CA-LT. This development package consists of objects that can be grouped under "Integrated Upgrade & Unicode Conversion: Main Package".
It is part of development package CNV_IUUC_MAIN in software component CA-LT. This development package consists of objects that can be grouped under "Integrated Upgrade & Unicode Conversion: Main Package".
Fields for table IUUC_PERF_OPTION
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MT_ID | Mass Transfer ID | X | DMC_MT_IDENTIFIER | CHAR | 6 | |
TABNAME | Table Name | X | TABNAME | CHAR | 60 | |
CLUSTER_PHYSICAL | IUUC: physical transfer of cluster tables | IUUC_PHYS_CLUST | CHAR | 2 | ||
LOGTAB_IN_RCV | create and fill logging table in receiver system | IUUC_LOGTAB_IN_RCV | CHAR | 2 | ||
PARALL_JOBS | number of parallel-running jobs for this table | IUUC_PARALL_JOBS | NUMC | 4 | ||
PARALL_FIELDNAME | fieldname of the field used to create distinct data portions | IUUC_PARAL_FIELD | CHAR | 60 | ||
SEQNUM | Sequence Number | DMC_SEQNR_TABLE | NUMC | 4 | ||
TABNAME_CLONE | Table Name | TABNAME | CHAR | 60 | ||
MAX_IN_BLOCK | max_in_blocking_factor (optimizer hint) | NUMC | 4 | |||
READING_TYPE | Reading Type | DMC_READING_TYPE | CHAR | 2 | ||
GENERIC_PARALLEL | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 2 | ||
NUM_RECS_LOGTAB | Number of records to be read from logging table | IUUC_NUMREC_LOGTAB | NUMC | 10 | ||
NUM_ORA_HASH_PAR | Number of Oracle Hash Partitions | IUUC_NUM_ORA_HASH_PARTITIONS | NUMC | 6 | ||
SEQUN_CACHE_SIZE | Sequence Cache Size | IUUC_SEQUENCE_CACHE_SIZE | NUMC | 10 | ||
SPC_LOGTAB_CLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | BOOLEAN | CHAR | 2 | ||
BLOCKSIZE | Block Size of an RFC Package | DMC_BLOCKSIZE | INT4 | 4 | ||
READ_SEQU_ORDER | Read Logging Table records in the order of their creation | IUUC_READ_IN_SEQUENCE_ORDER | CHAR | 2 | ||
ORACLE_RAC_OPT | Performance optimization for Oracle RAC | IUUC_ORA_RAC_OPT | CHAR | 2 | ||
NUM_CLUSTER_READ | Number of records for cluster buffer read access | IUUC_CLSTR_READ_SIZE | INT1 | 1 | ||
ORA_NO_LGPRM_IDX | Create Logging Table in Oracle Source without Primary Index | IUUC_ORA_NO_PRIMARY_LGTAB_INDX | CHAR | 2 | ||
NUM_HDB_HASH_PAR | Number of Logging Table Hash Partitions in HANA DB | IUUC_NUM_HDB_HASH_PARTITIONS | NUMC | 6 | ||
PARALL_REPL_JOBS | Number of Parallel Replication Jobs | IUUC_PARALL_REPL_JOBS | NUMC | 4 |