Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 UDB for z/OS > Migrating Data Using Siebel Enterprise Integration Manager > 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 have to run other SQL statements first. Resolving Performance Degradation During the Load ProcessWhen executing the EIM load process, performance might degrade noticeably after a number of batch loads are executed. This performance degradation often results when outdated statistics are loaded on the tables. To resolve the problem, update statistics on the target base tables. Resolving Errors in the EIM ProcessPerform the following steps to resolve errors that can occur during your EIM process:
|
Implementing Siebel Business Applications on DB2 UDB for z/OS | Copyright © 2008, Oracle. All rights reserved. | |