Problem Statement: During SAP Account/Access imports, several backup tables for default tables such as agr_agrs, agr_1251, etc. get created during each import cycle which contributes to performance issues...
Sample BackUp Temp Tables
distinct_temproletotcode_4450891_agr_agrs_20220403043125348_bkup
distinct_temproletotcode_4450907_agr_1251_20220403043810368_bkup
distinct_temproletotcode_4450907_agr_agrs_20220403043416398_bkup
distinct_temproletotcode_4450923_agr_agrs_20220403043915980_bkup
Solution: Navigate to Admin->Setting->Configuration Files, edit the externalconfig.properties file, and set the 'jobs.enableparallelimport.debugging' configuration to 'false'
Example:
# Disable parallel debugging by default.
jobs.enableparallelimport.debugging=false
This configuration specifies whether you want to create backup temp tables during SAP import. (available from Release v5.5 SP3.8 onwards)
The options are:
true - Creates backup temp tables.
false - Does not create backup temp tables.
