Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX > Upgrading the Siebel eBusiness Application > Reviewing the Upgrade Log Files >
Summarizing the Log Files
Use the log parse utility to create summary.txt, a 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.
NOTE: If you are upgrading from Release 7.5.2 and you plan to use database utilities to synchronize DDL or migrate a repository from development to production, rerun the Database Server Configuration Utility to create a new version of the UCF file. Save this UCF file to use when you run database utilities.
This step avoids encountering an error message when you run the logparse.exe utility that the UCF file is not compatible.To execute the log parse utility
- Type the following command from
$
SIEBEL_ROOT/
siebsrvr/bin
using the parameters specified in Table 14:
logparse.exe /s $
SIEBEL_ROOT
/g
LANGUAGE_CODE
/r
PROCESS
/l
LOGPARSE_FILENAME
/n
MAX_NUMBER_SQL
/t
THRESHOLD_TIME
/e
MAX_NUMBER_ERRORS
logparse.exe /s $
SIEBEL_ROOT
/g enu /r
upgrep_dev_601/l logparse.log /n
10/t
00:00:10/e
5The log parse utility creates
summary.txt
in the following directory:$SIEBEL_ROOT/siebsrvr
/log/
PROCESS
.To review the summary.txt file
- Open
summary.txt
from$SIEBEL_ROOT/siebsrvr
/log/
PROCESS
, wherePROCESS
is the database process you want to review.- Review the parameters to make sure they are correct.
- Review the step details for errors.
- For every error found, determine whether it is an acceptable error by following the procedure,.
- Review longest-running queries (based on the criteria you defined using the /t command line option).
- Review queries that returned zero rows (based on the criteria you defined using the /n command line option).
- Review the performance impact caused by table and index creation.
If no information is available, then the process did not execute DDL.
- Resolve any errors that occurred and, if necessary, restart the upgrade.
Bookshelf Home | Contents | Index | Search | PDF |
Upgrade Guide for UNIX Published: 20 October 2003 |