Upgrade Guide > Reviewing the Siebel Upgrade Log Files >
Summarizing Siebel Log Files Using Logparse
Upgrades: All Siebel upgrades. Environments: Development, production test, production. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. Use the log parse utility to create summary.txt and summary.html, a browser-based summary of all files in the log output directory. Use the summary file to review database process log files, verify parameters, review errors, and identify costly SQL and DDL steps. To execute the log parse utility
- Navigate to the following directory:
Windows: SIEBEL_ROOT \bin
UNIX: $SIEBEL_ROOT/bin
- Run the following command. Use the syntax in Table 33:
logparse /s install_dir /g LANGUAGE_CODE /r PROCESS /l LOGPARSE_FILENAME /n MAX_NUMBER_SQL /t THRESHOLD_TIME /e MAX_NUMBER_ERRORS
Table 33. Command Line Flags for Logparse
|
|
|
|
/s
|
install_dir_ |
Full path to the parent directory of SIEBEL_ROOT ($SIEBEL_ROOT). For example, if SIEBEL_ROOT is C:\sea7xx\siebsrvr , then install_dir is C:\sea7xx. Enclose the path in quotes. |
Required |
/g
|
LANGUAGE_CODE
|
The language code for the log files, for example enu . |
Required |
/r
|
PROCESS
|
Name of the schema process for which you want a summary generated, for example upgrep_dev_601. |
Default value=ALL (creates summary files for all processes in the output directory) |
/l
|
LOGPARSE_FILENAME
|
Name of the log parse log file. |
Default=logparse.log |
/n
|
MAX_NUMBER_SQL
|
Maximum number of longest-running SQLs to display in the summary. |
Default value=10 |
/t
|
THRESHOLD_TIME
|
Threshold time for longest running SQLs, in the format hh:mm:ss. |
Default value= 00:10:00 (By default, SQLs that run longer than 10 minutes are displayed) |
/e
|
MAX_NUMBER_ERRORS
|
Maximum number of errors to display in the summary. |
Default = 8 |
Windows example (language is English):
logparse /s C:\sea7xx /g enu /r upgrep_dev_704 /l logparse.log /n 10 /t 00:00:10 /e 5
The summary.html file automatically opens for your review if you executed the log parse utility for a single database process (that is, if you used the command line flag /r P ROCESS , where PROCESS =UPGRADEOPTION _ ENVIRONMENT _ VERSION ). If you executed the log parse utility for all processes in the output directory (that is, if you used the command line flag /r ALL ), you must manually open the summary file that you want to review. Log files appear in your primary language, but summary.html appears only in English (enu). To review the summary.html or summary.txt file
- If the summary file is not already open, open summary.html from the following directory:
Windows: SIEBEL_ROOT\log\PROCESS
UNIX: $SIEBEL_ROOT/log/ PROCESS ,
Where:
PROCESS is the database process you want to review.
UNIX: If a browser is not installed on the machine you are using, open summary.txt from $SIEBEL_ROOT/log/ PROCESS .
- Review the parameters to make sure they are correct.
- Review the step details for errors.
- If you are reviewing summary.html, select the
Steps/Errors link, then scroll down the page to review the step details for errors.
- If no errors occurred for a step, then the step detail displays
Errors:None .
- If more than five errors occurred for a step, the number of errors found appears as a link. Click the link to review all errors for that step.
- If you are reviewing summary.txt, scroll down to review the step details for errors.
If more than five errors occurred for a step, you must manually review the log files.
Summary.html and summary.txt only identify errors encountered by the ODBC driver for the database. Summary.html does not identify errors from Siebel utilities. To determine if errors were encountered by Siebel utilities, review the log files for these utilities.
- For every error found, determine whether it is an acceptable error by following the procedure Reviewing Siebel Upgrade Log Files for Errors.
If you are reviewing summary.html, click Back to return to the summary screen.
- Identify SQL steps that have the greatest performance impact by selecting the
Performance Information for SQL link in summary.html or by scrolling down to the following sections in summary.txt:
- Review the performance impact caused by table and index creation.
- If you are reviewing summary.html, select the
Performance Information for DDL link to review performance information.
This page may take a while to load due to its large size.
- If you are reviewing summary.txt, scroll down to review performance information.
If no information is available, then the process did not execute DDL.
- Resolve any errors that occurred and, if necessary, restart the upgrade.
|