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

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 set to 1
   • SQL flag set to 8
   • Trace flag set to 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. Remove unused indexes on base and EIM tables using the SQL DROP command.
15. Check space and resize table spaces if necessary.