Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS > 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 toTRUE
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 toTRUE,
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, resetUPDATE STATISTICS
toFALSE
for that process.For more information on RUNSTATS, see Maintenance Considerations for zSeries.
Bookshelf Home | Contents | Index | Search | PDF |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |