Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Migrating Data Using Siebel EIM > Improving EIM Performance During the Import Process >

Tuning Your 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

      This produces a log file with SQL statements and information about how long 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. Pay particular attention to 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 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. 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 STOSPACE on base tables. This collects storage information on DB2 objects.
  11. Perform RUNSTATS on base and EIM tables.
  12. Perform EXPLAINs to verify access path (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 eBusiness Applications on DB2 UDB for z/OS and OS/390