Reviewing Upgrade Performance

The Logparse summary file provides the input that Upgrade Tuner uses to analyze the performance of the upgrade scripts. For example, the summary file provides Upgrade Tuner with information about SQL commands that returned 0 rows.

If you plan to use the Upgrade Tuner to tune your production upgrade, then familiarize yourself with the performance information in the summary file.

To review upgrade performance in the summary file

If summary.html is not already open in your browser, then navigate to siebsrvr\log, and locate the subdirectory for the upgrade process you want to review.
In the desired upgrade process directory, click summary.html to open the file in a browser.
On the summary.html home page, Upgrade/Install Log File Navigation Page, locate the following columns:
- Performance Information for SQL
- Performance Information for DDL
Click the links in these columns to display performance information about the upgrade process.
The Performance Information for SQL page displays the longest running queries and queries that returned 0 rows for SQL scripts.
The Performance Information for DDL page displays the tables created, altered, and deleted by the ddlimp utility and by SQL scripts.
In both pages, the Net Cost column lists the time required to perform each operation.

To review upgrade performance in the summary file

Related Topics