How to move the ITCM database (mdb) to a different server
Article ID: 107018
Updated On:
Products
CA Automation Suite for Data Centers - Configuration Automation
CA Client Automation - Asset Management
CA Client Automation - IT Client Manager
CA Client Automation
CA Client Automation - Remote Control
CA Client Automation - Asset Intelligence
CA Client Automation - Desktop Migration Manager
CA Client Automation - Patch Manager
Issue/Introduction
What are the steps to move the ITCM database to a different server, and reconfigure the ITCM application server for the new database location?
Environment
Client Automation (ITCM) -- All supported versions.
Resolution
1- Run the following on the ITCM application server, in order to obtain the current values for the database configuration:
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbmsserver
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbmsinstance
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbname
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbuser
2- Before moving the database, stop the CAF service on the ITCM application server:
caf stop
3- Move the database server. In the case this is not being done by a DBA, there are essentially two approaches:
a) Detach and attach.
These are Microsoft SQL server specific tasks. You are "detaching" the database from the current server, which will allow you to move the associated files to the new database server, where you can "attach" the database.
b) Full backup and restore.
In this method, you run a full database backup, to file. Copy the full database backup to the new server, where you restore it, effectively recreating the entire database on the new server.
Either method is fine-- whatever gets the database over to the new server.
Once the database is restored, you will need to re-link the database user accounts, to the SQL server level:
exec sp_change_users_login 'AUTO_FIX', 'ca_itrm';
exec sp_change_users_login 'AUTO_FIX', 'ca_itrm_ams';
exec sp_change_users_login 'AUTO_FIX', 'cicuser';
Note: You may have to manually recreate the database user accounts (e.g. ca_itrm, ca_itrm_ams, cicuser) on the SQL server. Make them all public accounts, and you can leave the default database as "master". Then run the above three statements, to re-link the server accounts, to the existing database accounts, which will merge their configurations and permissions automatically.
4- Update the ITCM application server for the new location of the database:
ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbmsserver -v "newValue"
ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbmsinstance -v "newValue"
ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbname -v "newValue"
Notes:
- The itrm/database/default/dbuser parameter should not be changing-- will be "ca_itrm" both before and after the move!
- Be sure to match the formatting for the new values, with the formatting from the original values from step 1.
5- Update the dbo.ca_n_tier table in the ITCM database:
a) Check the current configuration values in the database:
select label, db_host_name, db_server
from ca_n_tier
where domain_uuid in (select set_val_uuid from ca_settings where set_id=1)
b) Update these configuration values, with the new values, following the same formatting:
update ca_n_tier
set label='newValue',
db_host_name='newValue',
db_server='newValue'
where domain_uuid in (select set_val_uuid from ca_settings where set_id=1)
6- Start the CAF service on the ITCM application server:
caf start
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbmsserver
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbmsinstance
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbname
ccnfcmda -cmd GetParameterValue -ps itrm/database/default -pn dbuser
2- Before moving the database, stop the CAF service on the ITCM application server:
caf stop
3- Move the database server. In the case this is not being done by a DBA, there are essentially two approaches:
a) Detach and attach.
These are Microsoft SQL server specific tasks. You are "detaching" the database from the current server, which will allow you to move the associated files to the new database server, where you can "attach" the database.
b) Full backup and restore.
In this method, you run a full database backup, to file. Copy the full database backup to the new server, where you restore it, effectively recreating the entire database on the new server.
Either method is fine-- whatever gets the database over to the new server.
Once the database is restored, you will need to re-link the database user accounts, to the SQL server level:
exec sp_change_users_login 'AUTO_FIX', 'ca_itrm';
exec sp_change_users_login 'AUTO_FIX', 'ca_itrm_ams';
exec sp_change_users_login 'AUTO_FIX', 'cicuser';
Note: You may have to manually recreate the database user accounts (e.g. ca_itrm, ca_itrm_ams, cicuser) on the SQL server. Make them all public accounts, and you can leave the default database as "master". Then run the above three statements, to re-link the server accounts, to the existing database accounts, which will merge their configurations and permissions automatically.
4- Update the ITCM application server for the new location of the database:
ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbmsserver -v "newValue"
ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbmsinstance -v "newValue"
ccnfcmda -cmd SetParameterValue -ps itrm/database/default -pn dbname -v "newValue"
Notes:
- The itrm/database/default/dbuser parameter should not be changing-- will be "ca_itrm" both before and after the move!
- Be sure to match the formatting for the new values, with the formatting from the original values from step 1.
5- Update the dbo.ca_n_tier table in the ITCM database:
a) Check the current configuration values in the database:
select label, db_host_name, db_server
from ca_n_tier
where domain_uuid in (select set_val_uuid from ca_settings where set_id=1)
b) Update these configuration values, with the new values, following the same formatting:
update ca_n_tier
set label='newValue',
db_host_name='newValue',
db_server='newValue'
where domain_uuid in (select set_val_uuid from ca_settings where set_id=1)
6- Start the CAF service on the ITCM application server:
caf start
Feedback
Yes
No
Powered by
