Siebel Database Upgrade Guide for DB2 for z/OS > Basic Database Preparations for a Siebel Upgrade >

Reviewing EIM Table Partitioning

Upgrades: All upgrades.

Environments: All environments.

Partitioning Siebel Enterprise Integration Manager (EIM) tables can improve EIM processing performance. In general, it is recommended that you partition EIM tables based on the IF_ROW_BATCH_NUM column. This method of partitioning allows an EIM batch input to be assigned to one partition, thereby allowing multiple EIM batches to be run in parallel.

Before you begin the database upgrade, review the current method of partitioning EIM tables in your implementation to make sure that it is still appropriate, and modify your partitioning keys if required. If you need help with reviewing the partitioning design of your EIM tables, contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance.

For additional information about EIM table portioning, see Implementing Siebel Business Applications on DB2 for z/OS.