1. Implementing Siebel Business Applications on DB2 for z/OS
  2. Example of Using a Non-U1 Partitioning Index

Example of Using a Non-U1 Partitioning Index

Although the recommended partitioning key for EIM tables is usually the U1 index (IF_ROW_BATCH_NUM and ROW_ID), in some cases, you might need to consider a different partitioning key.

The following examples illustrate how you might partition the EIM tables that are used to populate the S_ORG_EXT and S_OPTY target base tables. Using the columns shown ensures that the data is physically clustered based on the clustering index keys of the target tables.

  • EIM_ACCOUNT IF_ROW_BATCH_NUM ASC, NAME ASC, ACCNT_BI ASC, LOC ASC

  • EIM_OPTY IF_ROW_BATCH_NUM ASC, OPTY_NAME ASC

For information on using the Database Storage Configurator to perform your own custom partitioning of EIM tables, see Modifying a Storage Control File Using the Database Storage Configurator.