Upgrade Guide for DB2 UDB for z/OS > Reviewing the Database Upgrade Log Files > Reviewing Upgrade Log Files for Errors >

Reviewing the Log Files

Complete the following procedure to manually review log files for unacceptable errors.

To manually review the log files for unacceptable errors

1. Review the state1.log file to see at which step the upgrade failed. This step can be traced back to the driver file. The state1.log file is located in the following directory:

   Windows: SIEBEL_ROOT\log\PROCESS\state

   UNIX: $SIEBEL_ROOT/log/PROCESS/state

2. Print the errors file. The errors file lists the benign and expected errors you might find in the log files; you can ignore these errors. The errors file is located in the installation subdirectory:

   Windows: DBSRVR_ROOT\DB2390\errors.rtf or errors.htm

   UNIX: DBSRVR_ROOT/DB2390/errors.txt

3. Sort the files in the following directory by date.

   Windows: SIEBEL_ROOT\log\PROCESS\output

   UNIX: $SIEBEL_ROOT/log/PROCESS/output

4. Open each log file, starting with the earliest, and search for errors. Starting with the earliest log file can shorten your research time.

   Log files are identified by the .log extension. Errors are either tagged with the word error or enclosed in square brackets [...].

5. For each error found, compare the error description against the list of acceptable errors documented in the errors file.

   The log files generated by the Siebel Upgrade Wizard (for example srvrupgwiz1.log) appear in the errors file as upgwiz1.log, upgwiz2.log, incrementing for additional log files. Identify errors as follows:

   • If you find the error in the errors file, it is acceptable and no action is required. Continue to review the errors found in the log file.
   • If an error appears multiple times in a log file, but only one occurrence of that error appears in the errors file, all errors of that type are acceptable and no action is required. Continue to review the errors found in the log file.
   • If a log file is not listed in the errors file, there are no acceptable error messages for that log file. You must correct the condition that caused the error before you rerun the Siebel Upgrade Wizard.
   • If you find an error that is not listed in the errors file, it is unacceptable. You must correct the condition that caused the error before you rerun the Siebel Upgrade Wizard.

     To help resolve unacceptable errors, view 477324.1 (Article ID) on My Oracle Support. This document was formerly published as Siebel Troubleshooting Steps 21. Common errors and how to resolve them are listed in this document. If the error is not listed or you cannot resolve it, create a service request (SR) on My Oracle Support. Do not proceed with the upgrade.

6. Repeat Step 5 for each log file.

Although non-benign errors are rarely encountered, this review is critical. Certain errors, such as a failure to create indexes, may result in performance problems or anomalous behavior in Siebel Business applications.