Run the Database Cleanup Utility

During the installation of CA Service Management products, each of the installed product is registered in a common mdb table that is reflected in the deployment summary of the selected environment. These entries must be cleared in the following cases:
casm1401
During the installation of CA Service Management products, each of the installed product is registered in a common mdb table that is reflected in the deployment summary of the selected environment. These entries must be cleared in the following cases:
  • Uninstallation of any CA Service Management products
  • Moving Database or migration from one server to another
Run the CA Service Management database cleanup utility on a Windows or a Non-Windows environment. The database cleanup utility removes the entries and adds these to the following tables: 
Table Name from where the entries are removed
Table Name to which the removed entries are added
al_cdb_componentinstallstate
al_cdb_comp_installstate_bkup
al_cdb_configurationparameters
al_cdb_config_params_backup
On a Non-Windows Platform, before running the
DBCleanup.sh
Utility, you must export the Oracle Environment variables on the terminal.
Follow these steps
:
  1. Navigate to
    DVD1\DBCleanupUtility
    directory.
  2. For Windows, double-click the
    DBCleanupUtility.bat
    to launch the DBCleanup utility.
    On a Non-Windows platform, you must run the
    DBCleanupUtility.sh
    file.
  3. Enter the following details:
    1. Database Server Type
      : Specify the type of server, MS SQL or Oracle.
    2. Database Host Name:
      Enter the host name of the server where the database resides.
    3. Database User Name
      :
      • SQL Server
        : Enter the privileged user detail that has permission to create and modify schema.
      • Oracle
        :  Provide the mdbadmin  user name.
    4. Database Password
      :
      • MS SQL
        : Enter the database password used by the database admin user.
      • Oracle
        : Enter the password for the Oracle database user.
    5. Database Port Number:
      Provide the database port number.
    6. Enter Database Name
      :
      Enter the database name. For example, mdb.
    7. System Name
      : Provide the host name of the system from where you want to uninstall the CA Service Management product or products.
  4. Select any of the following products that you want to uninstall:
    • SDM -
      CA Service Desk Manager.
    • SLCM-
      CA Service Catalog.
    • ITAM -
      CA IT Asset Manager.
    • USS -
      Unified Self-Service.
      The utility cleans up the database and removes the entries of the selected product installed on the server.