Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 UDB for z/OS > Migrating Data Using Siebel Enterprise Integration Manager > About Setting Up EIM for DB2 > The RUNSTATS UtilityIf EIM performance degrades over time, consider running RUNSTATS against the base tables to update the optimizer statistics. If you set the parameter UPDATE STATISTICS to TRUE To execute EIM with UPDATE STATISTICS set to TRUE, the user account must have EXECUTE privileges on the DSNUTILS stored procedure and SYSADM, STATS, or DBADM privileges on the tables accessed. NOTE: Set UPDATE STATISTICS For more information on RUNSTATS, see DB2 Statistics for Siebel Business Applications. |
Implementing Siebel Business Applications on DB2 UDB for z/OS | Copyright © 2008, Oracle. All rights reserved. | |