1. Performance Tuning Guide
  2. Run Parameter Guidelines for Optimizing Siebel EIM

Run Parameter Guidelines for Optimizing Siebel EIM

The following recommendations are for setting run parameters when performing the Siebel EIM loading process:

  • Set UPDATE STATISTICS to FALSE and manually manage the statistics. The provided version of RUNSTATS that UPDATE STATISTICS calls uses SHRLEVEL REFERENCE, which will cause locking contention and other issues.

  • Do not set TRIM SPACES to FALSE. Using the TRIM SPACES parameter causes trailing spaces to be stored in the Siebel base table. This can lead to inefficient use of disk space since Siebel CRM uses VarChar on virtually all text columns longer than a single character. Setting TRIM SPACES to FALSE can also waste valuable bufferpool space for the tablespace data.

  • Use either the IGNORE BASE TABLES parameter or the ONLY BASE TABLES parameter to limit the number of tables being inserted into or updated. The ONLY BASE TABLES parameter is preferable because the list is usually shorter and it is self-documenting. Using these parameters improves performance because it limits the number of tables that Siebel EIM attempts to load and they also save space for tables that will not be used by the user interface.

  • Use either the IGNORE BASE COLUMNS parameter or the ONLY BASE COLUMNS parameter to limit the number of columns being inserted into or updated. The ONLY BASE COLUMNS parameter is preferable because the list is usually shorter and it is self-documenting. Using these parameters improves performance because they limit the number of foreign keys that Siebel EIM attempts to resolve.

  • Set the USING SYNONYMS parameter to FALSE in the IFB file. This logical operator indicates to Siebel EIM that account synonyms do not require processing during import, which reduces the amount of processing. Do not set the USING SYNONYMS parameter to FALSE if you plan to use multiple addresses for accounts. Otherwise, Siebel EIM will not attach addresses to the appropriate accounts.

  • Suppress inserts when the base table is already fully loaded and the table is the primary table for an EIM table used to load and update other tables. The command format is INSERT ROWS = table_name, FALSE.

  • Suppress updates when the base table is already fully loaded and does not require updates such as foreign key additions, but the table is the primary table for an EIM table used to load and update other tables. The command format is UPDATE ROWS = table_name, FALSE.