Bookshelf Home | Contents | Index | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Migrating Data Using Siebel EIM > Considerations for EIM TablesConsider the following issues when working with EIM tables. Updating the S_LST_OF_VAL TableThe BU_ID column in the S_LST_OF_VAL base table can have only one or very few distinct values. When this happens, the DB2 optimizer often needlessly performs a table scan through all rows in the S_LST_OF_VAL table. To avoid this problem and speed up the query, modify the statistics data by running the following SQL statements: update sysibm.sysindexes set firstkeycardf=1000 where update sysibm.syscolumns set colcardf = 1000 where tbname='S_LST_OF_VAL' and name='BU_ID'; NOTE: Depending on the data you are working with, you might need to run other SQL statements ahead of time. Resolving Performance Degradation During the Load ProcessWhen executing the EIM load process, performance might degrade noticeably over time, after subsequent batch loads. This performance degradation is often due to outdated statistics on the tables being loaded. To resolve the problem, update statistics on the target base tables. Resolving Errors in the EIM ProcessPerform the steps below to resolve errors that might occur during your EIM process:
|
Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 |