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".

Fields for table IUUC_PERF_OPTION

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MT_IDMass Transfer IDXDMC_MT_IDENTIFIERCHAR6
TABNAMETable NameXTABNAMECHAR60
CLUSTER_PHYSICALIUUC: physical transfer of cluster tablesIUUC_PHYS_CLUSTCHAR2
LOGTAB_IN_RCVcreate and fill logging table in receiver systemIUUC_LOGTAB_IN_RCVCHAR2
PARALL_JOBSnumber of parallel-running jobs for this tableIUUC_PARALL_JOBSNUMC4
PARALL_FIELDNAMEfieldname of the field used to create distinct data portionsIUUC_PARAL_FIELDCHAR60
SEQNUMSequence NumberDMC_SEQNR_TABLENUMC4
TABNAME_CLONETable NameTABNAMECHAR60
MAX_IN_BLOCKmax_in_blocking_factor (optimizer hint)NUMC4
READING_TYPEReading TypeDMC_READING_TYPECHAR2
GENERIC_PARALLELBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR2
NUM_RECS_LOGTABNumber of records to be read from logging tableIUUC_NUMREC_LOGTABNUMC10
NUM_ORA_HASH_PARNumber of Oracle Hash PartitionsIUUC_NUM_ORA_HASH_PARTITIONSNUMC6
SEQUN_CACHE_SIZESequence Cache SizeIUUC_SEQUENCE_CACHE_SIZENUMC10
SPC_LOGTAB_CLEANBoolean Variable (X = True, - = False, Space = Unknown)BOOLEANCHAR2
BLOCKSIZEBlock Size of an RFC PackageDMC_BLOCKSIZEINT44
READ_SEQU_ORDERRead Logging Table records in the order of their creationIUUC_READ_IN_SEQUENCE_ORDERCHAR2
ORACLE_RAC_OPTPerformance optimization for Oracle RACIUUC_ORA_RAC_OPTCHAR2
NUM_CLUSTER_READNumber of records for cluster buffer read accessIUUC_CLSTR_READ_SIZEINT11
ORA_NO_LGPRM_IDXCreate Logging Table in Oracle Source without Primary IndexIUUC_ORA_NO_PRIMARY_LGTAB_INDXCHAR2
NUM_HDB_HASH_PARNumber of Logging Table Hash Partitions in HANA DBIUUC_NUM_HDB_HASH_PARTITIONSNUMC6
PARALL_REPL_JOBSNumber of Parallel Replication JobsIUUC_PARALL_REPL_JOBSNUMC4
Privacy Policy