- Review the contents of the Catalog database:
- The CA Management Database (MDB) tables that apply to CA Service Catalog; their names typically begin with a CA_ prefix. The MDB is the common, shared database for CA Technologies products. The MDB provides the database schema for CA Service Catalog and other CA Technologies products.
- The CA Service Catalog-specific tables; their names typically begin with a USM_ prefix. These tables are not included in the MDB.
- Back up your existing Catalog database on the computer where it currently resides.
Note: For instructions to back up the Catalog database, see your DBMS documentation.
- Optimize the System Change Detail tables.
- If applicable, on your DBMS server, upgrade your Oracle or SQL Server software to a supported version: Oracle 11gr2 or SQL Server 2008 or 2012.
- Review the CA Management Database (MDB) documentation, which is supplied with other documents on the CA Service Catalog installation media. Note the most applicable information for your implementation plans, and keep it on hand for reference.
- Apply all patches and other maintenance for your DBMS (SQL Server or Oracle).
Note: For details, see your SQL Server or Oracle documentation.
- 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.
- Verify that the DBMS client software is installed on the computer from which you plan to run the installation program.
- (SQL Server Only) Work with your DBA to determine whether organizational policy permits the user installing or upgrading CA Service Catalog to have system administrator (SA) privileges in SQL Server. Proceed as follows:
- If Yes, use a user ID that has SA privileges to install or upgrade CA Service Catalog. No further action is necessary.
- If No, create the database user with the required privileges to install or upgrade the product but without SA privileges.
- (CA Workflow Only) If you are using CA Workflow, review the post-installation task to update the database and re-install CA Workflow. Read it now to become familiar with the steps required after you install or upgrade CA Service Catalog.
Important! CA Workflow is no longer being enhanced, and its maintenance and technical support are scheduled to be discontinued as of December 31, 2013. Therefore, we strongly recommend using CA Process Automation as your process automation tool.
You have prepared the Catalog database and the DBMS.
