Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Migrating Data Using Siebel EIM > Setting Up EIM for DB2 >
Using the RUNSTATS Utility
If EIM performance degrades over time, consider running RUNSTATS against the base tables to update the optimizer statistics.
If the parameter
UPDATE STATISTICS is set to
TRUE in your
.ifb file, the EIM process invokes the DSNUTILS stored procedure. This allows EIM to perform RUNSTATS dynamically on temporary columns to get optimal statistics numbers in the DB2 catalog. The IBM DSNUTILS stored procedure must be installed and the OS/390 WLM manager should be enabled.
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.
UPDATE STATISTICS = TRUE only once to collect proper statistics for each given EIM process. As soon as this is done, reset
UPDATE STATISTICS to
FALSE for that process.
For more information on RUNSTATS, see Maintenance Considerations for zSeries.