Bookshelf Home | Contents | Index | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Migrating Data Using Siebel EIM > Setting Up EIM for DB2 > Choosing an Appropriate Partitioning SchemeTo achieve the best system throughput, partition base tables and EIM tables and set up parallel EIM processes to efficiently exploit partitioned EIM table spaces. When a table is created on a partitioned table space, the table is assigned a partitioning key composed of one or more columns. EIM tables by default use a clustering U1 index in the order of IF_ROW_BATCH_NUM, ROW_ID. In some cases, you can obtain better performance by partitioning EIM tables based on the partitioning key of the target base table, for example, on IF_ROW_BATCH_NUM plus the partitioning key of the corresponding target table. NOTE: The values in this key should not be updated. Changes to values in the partitioning key might require unloading and reloading or performing a REORG on the data to resolve performance issues. For more information on DB2 partitioning, see Understanding Siebel Partitioning. |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 |