Implementing Siebel Business Applications on DB2 UDB for z/OS > Migrating Data Using Siebel Enterprise Integration Manager > How to Improve EIM Performance When Importing >

Tuning the EIM Import Process


Review and tune your EIM process for each set of business data you load, for example, Opportunities, Contacts, or Products.

To tune each EIM import process

  1. Load a single batch with the following flags set in your configuration file:
    • Error flag = 1
    • SQL flag = 8
    • Trace flag = 3

      Setting these flags produces a log file containing SQL statements and information about the length of time each statement took to execute.

  2. Identify SQL statements that might be taking too long to execute.
  3. Using the DB2 EXPLAIN utility, populate the explain table with information on how the DB2 Optimizer is executing each of these SQL statements.

    Carefully review any changes in the default optimization level in the EIM log.

  4. Based on the Access Plan and other information from the EXPLAIN output, determine the required indexes for EIM and base tables.
  5. Run EIM with parameters to reach each partition and repeat single process tuning.
  6. Perform .ifb file tuning for each process, and remove unnecessary foreign keys.
  7. Execute the REORG utility on base tables to build a compression dictionary.
  8. Perform parallel process tuning.
  9. Perform buffer pool tuning.
  10. Execute the STOSPACE utility on base tables. This collects storage information on DB2 objects.
  11. Run the RUNSTATS utility on base tables and EIM tables.
  12. Use SQL explain tools to verify access paths (required indexes).
  13. Modify statistics if required.
  14. Drop unused indexes on base and EIM tables.
  15. Check space and resize table spaces if necessary.
Implementing Siebel Business Applications on DB2 UDB for z/OS Copyright © 2008, Oracle. All rights reserved.