Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 for z/OS > Migrating Data Using Siebel Enterprise Integration Manager > How to Improve EIM Performance When Importing Data > About Improving EIM Performance During Initial LoadsSome considerations relating to improving EIM performance apply only during an initial load of data into your Siebel application. These considerations are described in the following sections. Unused, Nonunique IndexesThe initial load of data is typically a database-intensive process. Each row that is inserted into the base table requires modifications, not only to the table itself, but to all its affected indexes. However, most of these indexes are never used during an initial load process. You can usually improve performance by determining which base table indexes are unused by EIM during the import process and removing them prior to the initial load using SQL DROP commands. You must later re-create these indexes. Unused TriggersRemoving unused triggers can improve import performance by reducing the database system overhead used to verify trigger constraints. You can use the Generate Triggers (GenTrig) component from Siebel Server Tasks to remove the triggers and to re-create them later on. This component must be in the Enabled state. For details on how to work with Generate Triggers, see Siebel Business Process Framework: Workflow Guide. NOTE: If you are using partitioning, do not remove triggers that are used for partitioning purposes from the database. If you do, your EIM process fails, or it inserts all the data in a single partition. Free Space ParametersIf you use your Siebel application primarily for queries, updates, and deletions, alter your table spaces and indexes to provide optimal insert and update performance. To improve the EIM import and update SQL performance, set PCTFREE for table spaces and indexes to a value of 20 or 30 prior to the EIM initial load, and maintain these settings at 20 or 30 for subsequent loads. Insert Performance on Base TablesYou can improve the insert performance on base tables during an initial load of data into your Siebel application by following these guidelines:
Alter base table spaces to PCTFREE and FREEPAGE values of 20 or 30 for subsequent import processes. It is also recommended that you load or reorganize any altered items before the new values take effect. The following example demonstrates how to set these values for your table spaces and indexes. Substitute your own table space and index names for your implementation. ALTER TABLESPACE SIDB0401.H0401000 PART 1 PCTFREE 20; ALTER INDEX SIDB0401.S_ADDR_ORG_M6 PCTFREE 20; Transaction LoggingSiebel transaction logging is unnecessary during an initial EIM load, and should be disabled by setting |
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |