EIM performance decreased when using DEFAULT COLUMN in ifb file
Last updated on MAY 01, 2018
Applies to:Siebel Enterprise Integration Manager - Version 18.104.22.168 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 22.214.171.124  DEU Fin Svcs
Database: IBM DB2 8.1 FixPack 3
Application Server OS: Microsoft Windows 2000 Advanced Server SP 3
Database Server OS: Microsoft Windows 2000 Advanced Server SP 3
This document was previously published as Siebel SR 38-1475736921.
***Checked for relevance on 06-Feb-2013***
""Checked for relevance on 13-May-2016""
We plan to import ~ 300000 activities using EIM. We are now trying to speed up the process. We found that for each single fixed column, EIM will execute one update - statement on the EIM-table (see attached log file). Since we have 25 fixed columns (see attached ifb file), EIM executes 25 update statements with the same "where" - clause. Each takes around 3 minutes.
Why doesn't EIM just execute one update statement that updates all 25 columns instead of updating the columns one by one ?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms