How to point CA APM to a new MDB location

Document ID : KB000097072
Last Modified Date : 18/05/2018
Show Technical Document Details
Introduction:
We have moved the CA APM MDB to a new SQL Server. How do we reconfigure the existing CA APM installation to point to the new SQL Server?
Instructions:
1) Stop all APM services on the APM application server(s).

2) On the target mdb, view the al_cdb_configurationparameters table for the database connection parameters (see below).

select * from al_cdb_configurationparameters where componentkey = 'Database'

Use these update statements to update the database connection values to the appropriate values for the target mdb:

update al_cdb_configurationparameters set configvalue = '' where configkey = 'Database Owner'
update al_cdb_configurationparameters set configvalue = '' where configkey = 'DBInstance'
update al_cdb_configurationparameters set configvalue = '' where configkey = 'DbLogin'
update al_cdb_configurationparameters set configvalue = '' where configkey = 'DbNameTxt'
update al_cdb_configurationparameters set configvalue = '' where configkey = 'DBPassword'
update al_cdb_configurationparameters set configvalue = '' where configkey = 'DbTcpIpPort'
update al_cdb_configurationparameters set configvalue = '' where configkey = 'HostName'
update al_cdb_configurationparameters set configvalue = '' where configkey = 'MdbadminPassword'

3) On the APM web server, edit the \CA\ITAM\Web Server\bin\CA.Common.LoadConfigurationAttributes.dll.config file and verify or change the database connection entries:

<add key="UserID" value="sa"/>
<add key="Password" value="rpVTWUM9HF6HVCKfcKnAyw=="/>
<add key="HostName" value="tcp:<hostname>,1433"/>
<add key="DatabaseName" value="<DBNAME>"/>

4) Copy the CA.Common.LoadConfigurationAttributes.dll.config file and replace it in the following directories:

\Program Files (x86)\CA\ITAM\Application Server\bin
\Program Files (x86)\CA\ITAM\Data Importer Engine
\Program Files (x86)\CA\ITAM\Export Service
\Program Files (x86)\CA\ITAM\Event Service
C:\Program Files (x86)\CA\ITAM\Hardware Engine
C:\Program Files (x86)\CA\ITAM\Import Driver
C:\Program Files (x86)\CA\ITAM\Import Processor
C:\Program Files (x86)\CA\ITAM\LDAP Import Sync Service
C:\Program Files (x86)\CA\ITAM\Registration Service
C:\Program Files (x86)\CA\ITAM\Storage Manager Service\bin
C:\Program Files (x86)\CA\ITAM\WCF Service\bin

5) Perform an IISRESET on BOTH the APM web and APM application servers