Siebel Database Upgrade Guide > How the Siebel Database Upgrade Works >
About the Siebel Database Upgrade Log Files
Upgrades from: All Siebel releases. Environments: Development, production test, production. Platforms: Windows and UNIX only. Does not apply to IBM z/OS. The Upgrade Wizard writes log files that provide detailed information on the upgrade processes, for example development-environment upgrep and upgphys. These log files provide detailed information on the upgrade steps, and they also list all errors. The Logparse utility analyzes and summarizes these log files. Upgrade Wizard Log Files
The Upgrade Wizard writes the log files for a process to the following directory: Windows: SIEBEL_ROOT\log\PROCESS
UNIX: $SIEBEL_ROOT/log/ PROCESS
where PROCESS defaults to UPGRADEOPTION _ ENVIRONMENT _ VERSION .
For example, the log files for a Siebel 7.7 development environment upgrep appear in the following locations: Windows: SIEBEL_ROOT\log\ upgrep_dev_77
UNIX: $SIEBEL_ROOT/log/upgrep_dev_77
You can select a different directory for the log files in the Log Output Directory screen in the Database Server Configuration Utilities. Each subdirectory in the log directory contains the following files:
The Logparse Utility
For each upgrade process, the Logparse utility analyzes the Upgrade Wizard 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 and by SQL scripts. It does not list errors returned by upgrade utilities called by the driver files, such as ddlimp and dataimp. You must review the upgrade logs for these utilities separately. The detailed step summary lists all errors found in the log files, including benign errors. An errors file (errors.xls, errors.rtf, and errors.txt ) is provided that list benign errors for each database type. When you find an error in the summary.html file , you must compare it to the errors file to determine if it is benign.
The performance report provides a list of the longest running SQL scripts and a list of SQL scripts returning 0 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. Platforms: MS Windows, UNIX, IBM z/OS.
|