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.

NOTE:  Set 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.