Tuesday, July 15, 2014

Using SQLPROFILE Parameter in IFB file

The inclusion of this parameter will greatly simplify the task of identifying the most expensive SQL statements. The insert of the following statement in the header section of the “IFB” file will place the most expensive SQL statements into the file:

SQLPROFILE = c:\temp\eimsql.sql

Below is an example of the file “eimsql.sql”:

<Start of the file – list of most expensive queries>

<…list of queries continues>

<Statistics by step and by pass>

<…list of statistics continues>

<SQL statements>

<…list of SQL statements continues>