My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

Applies to:

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


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 ?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.