EIM performance decreased when using DEFAULT COLUMN in ifb file (Doc ID 546622.1)

Last updated on MAY 13, 2016

Applies to:

Siebel Enterprise Integration Manager - Version 7.5.3.5 SIA [16183] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.5 [16183] 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""


Symptoms

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 ?



Cause

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