Bookshelf Home | Contents | Index | PDF |
Implementing Siebel Business Applications on DB2 for z/OS > Migrating Data Using Siebel Enterprise Integration Manager > About Setting Up EIM for DB2 > 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. For more information on RUNSTATS, see DB2 Statistics for Siebel Business Applications. NOTE: Set UPDATE STATISTICS |
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |