Viewing the optimization log

The optimization log shows details about which optimizations were attempted on your job and in what order.

The final optimization is the result of trying many patterns, and retrying patterns as the job is changed by previous patterns. The details of what optimizations were tried and in what order, what they did when they succeeded, and details of why they did not succeed, are logged.

There are two optimization log files:
  • optimizerMain.log which contains all the Balanced Optimization log entries including both Java and Prolog log entries.
  • optimizer.log which contains only the Prolog log entries. These log entries are also displayed in the log tab in the Balanced Optimization window.

On Windows 7, the optimization logs isin the directory C:\Users\user\AppData\Roaming\IBM\InformationServer\DataStage Client\clientTagID\BalOp\logs.

On earlier versions of Windows, the optimization logs is in the directory C:\Documents and Settings\user\Application Data\IBM\InformationServer\DataStage Client\clientTagID\BalOp\logs.

  1. Optional: To turn on detailed debug messages set the prolog.loglevel property to debug in the gandalf.properties properties file.

    On Windows 7 the gandalf.properties properties file is in the C:\Users\user\AppData\Roaming\IBM\InformationServer\DataStage Client\clientTagID\BalOp\etc directory.

    On earlier versions of Windows, the gandalf.properties properties file is in the C:\Documents and Settings\user\Application Data\IBM\InformationServer\DataStage Client\clientTagID\BalOp\etc directory.

    To turn off detailed debug messages set the prolog.loglevel property to none in the gandalf.properties properties file.

  2. Optimize your job.
  3. In the Optimize window, click the Log tab.
  4. View the log details. The log messages are color-coded.