Implementing Siebel Business Applications on DB2 UDB for z/OS > Migrating Data Using Siebel EIM > About Setting Up EIM for DB2 >

The SQLPROFILE Log

The 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).