The Logparse Utility

For each upgrade process, the Logparse utility analyzes the log files in siebsrvr\log\process. It then summarizes the log files and provides several reports. The Logparse reports provide the following information.

Parameters Report

The Parameters report lists the total time required for the upgrade process. It also lists environment variables and input files used by the upgrade process. Use this report to verify that the upgrade was set up correctly.

Step/Error Summary

The Step/Error Summary lists each step in the upgrade process and whether it completed successfully. It also provides a link to a detailed step summary for each step.

The detailed step summary lists database errors returned by the Upgrade Wizard, SQL scripts, and errors returned by the upgrade utilities called by the driver files, such as ddlimp, and dataimp.

For Oracle Database and IBM DB2, the detailed step summary lists only unacceptable errors that must be corrected. The summary does not list benign errors.

For Microsoft SQL Server, the detailed step summary lists all errors, including benign errors. An errors file (errors.xls and errors.rtf) is provided that lists benign errors for each database type. When you find an error in the summary.html file, you must compare it with the error file to determine whether it is benign.

Performance Report

The performance report provides a list of the longest running SQL scripts and a list of SQL scripts returning no rows. The lists include a link to each script. Upgrade Tuner uses this information as input to help you tune upgrade performance.

The report also provides two lists of DDL commands executed during the upgrade process. The DDL Summary lists the tables that were created, altered, or deleted by the ddlimp utility. The Native DDL Summary lists tables that were created, altered, or deleted by SQL scripts and includes a link to each script.