Rename the ITCM MDB Database on standalone Domain Manager
search cancel

Rename the ITCM MDB Database on standalone Domain Manager

book

Article ID: 438775

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager CA Client Automation

Issue/Introduction

ITCM MDB database needs to be renamed in Microsoft SQL Server.

How to rename the MDB database in Client Automation ? Is it a supported operation ?

Environment

Client Automation - All Versions
Microsoft SQL Server
Standalone Domain Manager (no linked to an enterprise)

Resolution

While renaming the MDB is technically possible through specific configuration changes, it is officially unsupported and has not been certified by Engineering.

Renaming the MDB database is a three-part process involving updates to the local Comstore, the database and in CIC configuration file.

 

1. Update the Local Comstore

On the Domain Manager, use the ccnfcmda utility to point the application to the new database name. Run the following command in an administrative command prompt:

ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbname -v "<new_mdb_name>"

(Note: Replace <new_mdb_name> with the new database name.)

 

2. Update the Database Table

The sql table ca_n_tier must be updated to match the new database name. Execute the following SQL query against the renamed MDB:

UPDATE ca_n_tier SET db_name='<new_mdb_name>' WHERE domain_uuid = (SELECT set_val_uuid FROM ca_settings WHERE set_id=1)


3. Update the CIC Configuration

  1. Navigate to the CIC configuration folder: C:\Program Files (x86)\CA\SC\CIC\conf\
  2. Open config.xml in a text editor.
  3. Locate the <dbname> tag and update the value to the new database name: <dbname>new_mdb_name</dbname>
  4. Save the file.

4. Restart Services

To apply the new configuration, restart the CAF services:

caf stop
caf start

Powered by Wolken Software