Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > Migrating Data Using Siebel EIM > Setting Up EIM for DB2 >

Choosing an Optimal Number of Parallel Streams

A rule to determine how many batches can run simultaneously is that the combined number of parallel streams should keep the CPU 100% busy. These can either be multiple EIM processes running simultaneously or the same EIM process repeated against multiple partitions of the same table.

Running EIM processes in parallel on a DB2 database with the default setting of UPDATE STATISTICS = TRUE can cause a deadlock when multiple EIM processes access the same interface table simultaneously. To avoid a deadlock, set UPDATE STATISTICS = FALSE in the EIM configuration file.

A similar problem might occur if parallel processes access the same child tables while updating foreign keys. Therefore, analyze your EIM mappings and processes and do not run these processes in parallel. Alternatively, you can try altering the locking level from Page to Row.


 Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS 
 Published: 18 April 2003