Process of a major upgrade

You will run an out-of-box upgrade on this system, and then fix errors and resolve conflicts. Make sure the development system meets the requirements in the support matrix of the target upgrade version, and copy your production data to the development system.

Prepare the data and binaries (server and client) of the development system for an upgrade.

1. Purge and archive unnecessary data to optimize upgrade performance.

   Purge and archive unnecessary data in the following files (which may contain large amounts of data): mail, msglog, syslog, spool, eventin, eventout, schedule, sysperform, and devaudit (on a production system, development auditing should be turned off).

   For information about purging and archiving records, see the Service Manager Help Center.

2. Meet database requirements.

   1. Keep the table space name same as the production system for an Oracle database.
   2. Convert all column names to uppercase for a case-sensitive database.
   3. Remove some indexes and constraints.
3. Upgrade your Service Manager server and client to the latest version.

4. Update the server configuration files (sm.cfg and sm.ini).

   Before running the Upgrade Utility, you need to make changes to the Service Manager configuration files before running the Upgrade Utility. Record all changes that you have made so that you can revert them to the original status after the upgrade.

1. Check the size of the applications upgrade data, and compare it with the out-of-box upgrade package to make sure the downloaded data has no problems.

2. Load applications upgrade file preupg.bin from the out-of-box upgrade package.

3. Log off and then log back in.

4. Apply the out-of-box upgrade package to the development system.

5. Log out, restart the server, and then log back in.

1. Fix all exceptions in the except.log file, and verify your fixes.
2. Resolve all conflicts in the upgraderesults table, and verify your conflict resolution results.

3. Perform additional manual tasks.

Return the development system to normal operation, and test the upgraded development system.

Now you have resolved all the exceptions and conflicts. It is necessary to package all the reconciled objects together into a "custom upgrade" so that they can be moved into the production environment automatically.

You need to apply the newly-created custom upgrade to your test system for user acceptance testing. Make sure the test system meets the requirements in the support matrix of the target upgrade version, and then copy your production data to the test system.

Follow the same steps for the development system, as described in step 2.

1. Upgrade the Service Manager server and client to the latest version for your test system.

2. Load applications upgrade file preupg.bin from the custom upgrade package.

3. Log off and then log back in.

4. Apply the custom upgrade package to the test system.

5. Fix all exceptions in the except.log file, and verify your fixes.

6. Resolve all "Error" results in the upgraderesults table, and verify your resolution results.

Return the test system to normal operation, and test the custom upgrade.

Test all features that your users will access. Pay particular attention to areas that were modified on your system.

If there are errors found in the test system, fix them in the development system and then go to step 6.

Follow the same steps for the development system, as described in step 2.

Make sure you have thoroughly tested the custom upgrade, before you apply the newly-created custom upgrade to your production system. This process is identical to the one you followed when applying your upgrade to your test system.