Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390 > Migrating Data Using Siebel EIM > Setting Up EIM for DB2 >
Reviewing the SQLPROFILE Log
SQLPROFILE parameter in the header of your EIM configuration (
.ifb) file designates the file to which EIM writes an analysis of the worst-performing SQL queries overall (by total time) and the worst-performing statements in each step of the EIM process (also by total time), for example:
[Siebel Interface Manager]
PROCESS = Import Products
SQLPROFILE = topsql.log
Review this log file after the test run of each EIM process to determine where potential bottlenecks exist in your process. Based on the results of this log, either adjust mapping and IFB parameters, or perform normal DB2 tuning (such as adding an index to improve the access path).