Siebel EIM

Siebel Enterprise Integration Manager (EIM) manages the bi-directional exchange of data between the Siebel database tables and other corporate databases.

Multiple EIM processes can be executed against an EIM table provided they all use different batches or batch ranges. The concern is that contention for locks on common objects may be experienced.

One other measure that can help performance is to pin small tables that are frequently accessed in cache.

When purging data from the EIM table, use the TRUNCATE command as opposed to DELETE.

Prior to running EIM it is important to clean up fragmented objects, especially those that will be used during the EIM processing. The following SQL statement can be used to identify objects with greater than 10 extents:

Use DB2 load replace option when loading EIM tables and turn off table logging if possible.Use separate