How the DBCleanup.exe utility works in Service Desk

Products

• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

The purpose of DB Cleanup utility is to remove any leftover data after any of the product components in CA Service Management is uninstalled.

This leftover data is removed from in al_cdb_configurationparameters table and related tables within the MDB. 

Running this executable will not have an impact on other MDB tables or Data.

NOTE: We recommend backing up the database before running this tool

Environment

Release: CA Service Desk Manager 17.x 

Resolution

Since this utility modifies the database, we recommend taking a backup of the database before running this tool.

The DBCleanup Utility is accessible via the Service Management Install media, under the DVD1\DBCleanupUtility directory.

To run the utility, Double-click the DBCleanupUtility.bat to launch the DB Cleanup utility.

Follow the on screen instructions and select only the products that have been uninstalled form that host as shown the below example screenshot:

Enter the following details:

Database Server Type: Specify the type of server, MS SQL or Oracle.

Database Host Name: Enter the host name of the server where the database resides.

Database User Name:

SQL Server: Enter the privileged user detail that has permission to create and modify schema.

Oracle: Provide the mdbadmin user name.

Database Password:

MS SQL: Enter the database password used by the database admin user.

Oracle: Enter the password for the Oracle database user.

Database Port Number: Provide the database port number.

Enter Database Name: Enter the database name. For example, mdb.

System Name: Provide the host name of the system from where you want to uninstall the CA Service Management product or products.

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.

If you find any references to the removed server, you can delete the found data, but be sure to confirm product functionality and revert to the backups in case issues are found. 

Additional Information

Run the Database Cleanup Utility