Upgrading › Prepare for the Upgrade › Prepare the MDB and the DBMS

Previous Topic: Prepare for the Upgrade

Next Topic: Back Up CA EEM Data

Prepare the MDB and the DBMS

Preparing the MDB and the DBMS is a required task whether you upgrade using a migration model or a traditional model.

Follow these steps:

  1. Back up your existing CA MDB on the computer where it currently resides.

    Note: For instructions to back up CA MDB, see your DBMS documentation.

  2. (Recommended) Clean the usm_system_change_detail database table, as explained in this step and the next step.

    These steps are optional and are recommended to help improve the performance of the product. These steps can require from several minutes to an hour, depending on the volume of the data in the table.

    1. Run the following command: 
      select * into usm_system_change_detail_temp from usm_system_change_detail where old_value!=new_value

      This command copies the required data to a temporary table.

    2. Back up the script for all constraints for the following tables:
      • usm_system_change_detail
      • usm_system_change_detail_ext
  3. Do the following, if you performed the previous step:
    1. Drop the foreign key constraints for the usm_system_change_detail_ext table.
    2. Drop the usm_system_change_detail table.
    3. Rename the usm_system_change_detail_temp table to usm_system_change_detail.
    4. Use the script that you backed up in the previous step to create indexes for the usm_system_change_detail and usm_system_change_detail_ext tables.
  4. If applicable, on your DBMS server, upgrade your Oracle or SQL Server software to a supported version: Oracle 10g or 11g or SQL Server 2005 or 2008.
  5. Verify that the Oracle or SQL Server client software is installed on each required computer. The version installed on the client must match the version installed on the DBMS server.

    The required computers are the new CA Service Catalog computers, on which you plan to install or upgrade one or more CA Service Catalog products or components.

  6. Remove replication in your DBMS.

    Important! When replication has been added, the database tables are locked from any schema changes, even if replication is turned off. As a result, the upgrade cannot run successfully.

    Note: For instructions to remove replication, see your DBMS documentation. Also see that documentation for instructions to add it again, after you have completed the upgrade.

You have prepared the MDB and the DBMS.