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 Utility
If 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
in your EIM configuration file (.ifb), the EIM process invokes the DSNUTILS stored procedure. This procedure allows EIM to perform RUNSTATS dynamically on temporary columns to obtain optimal statistics numbers in the DB2 catalog. You must install the IBM DSNUTILS stored procedure and enable the z/OS WLM manager.
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
to TRUE only once to collect proper statistics for each given EIM process. As soon as the statistic are collected, reset UPDATE STATISTICS to FALSE
for that process.
For more information on RUNSTATS, see DB2 Statistics for Siebel Business Applications.