|
Siebel Database Upgrade Guide > Reviewing the Siebel Upgrade Log Files >
Summarizing Siebel Log Files Using the Logparse Utility
Environments: Development, production test, production. Platforms: Windows and UNIX only. Does not apply to IBM z/OS. Use the Logparse utility to analyze and summarize the log files created when you run the Upgrade Wizard. The Logparse utility writes its findings to a summary file: Windows: SIEBEL_ROOT\log\PROCESS\summary.html
UNIX: $SIEBEL_ROOT/log/PROCESS/summary.html
where:
Process is the upgrade process you want to review, for example, upgrep_dev_8x
The Logparse utility also writes a summary.txt file that contains the same information as summary.html. Use the summary.txt file if you do not have a browser. After writing the output files, the Logparse utility opens summary.html automatically. Table 24 lists the command line syntax for the Logparse utility.
Table 24. Command Line Syntax for the Logparse Utility
|
|
|
|
/s
|
install_dir |
Full path to the parent directory of SIEBEL_ROOT ($SIEBEL_ROOT). For example, if SIEBEL_ROOT is C:\sba8x\siebsrvr, then install_dir is C:\sba8x. Enclose the path in quotes. |
Required |
/g
|
LANGUAGE_CODE
|
The language in which the Upgrade Wizard ran. This is called the resource language, and typically is the language in which you ran the Siebel Installation Wizard. For example, if the resource language is English, then the language code is enu. |
Required |
/r
|
PROCESS
|
Name of the schema process for which you want to generate a summary file, for example upgrep_dev_8x. To obtain the schema process name, look in \siebsrvr\log. The subdirectory names in \log are the schema process names. |
Required. |
/l
|
LOGPARSE_FILENAME
|
Name of the Logparse log file. |
Default value is logparse.log |
/n
|
MAX_NUMBER_SQL
|
Maximum number of longest-running SQL to display in the summary. |
Default value is 10 |
/t
|
THRESHOLD_TIME
|
Threshold time for longest running SQL, in the format hh:mm:ss. |
Default value is 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 is 8 |
To run the Logparse utility
- Navigate to the following directory:
Windows: SIEBEL_ROOT\bin
UNIX: $SIEBEL_ROOT/bin
- Run the following command. Use the syntax in Table 24:
logparse /s install_dir /g LANGUAGE_CODE /r PROCESS /l LOGPARSE_FILENAME
/n MAX_NUMBER_SQL /t THRESHOLD_TIME /e MAX_NUMBER_ERRORS
Windows example (Upgrade Wizard language is English):
logparse /s C:\sea8xx /g enu /r upgrep_dev_8xx /l logparse.log /n 10 /t 00:00:10
/e 10
- Review the Logparse log and verify that Logparse ran without errors.
Windows: SIEBEL_ROOT\bin\logparse.log
UNIX: $SIEBEL_ROOT/bin/logparse.log
Related Topics
About the Siebel Database Upgrade Log Files
Reviewing Siebel Upgrade Log Files for Errors
| 
