Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS > Migrating Data Using Siebel Enterprise Integration Manager > About Setting Up EIM for DB2 > The SQLPROFILE LogThe SQLPROFILE parameter in the header of your EIM configuration file (.ifb) 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] 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). |
![]() |
![]() ![]() |
Implementing Siebel Business Applications on DB2 UDB for z/OS | Copyright © 2008, Oracle. All rights reserved. | |