Cisco CallManager Administration Guide, Release 4.1(3) - Removing a Subscriber Server from Cisco CallManager (Revised 07/25/2005) [Cisco Unified Communications Manager (CallManager)]

Table Of Contents

Removing a Subscriber Server from Cisco CallManager

Remove SQL Replication Information

Run RemoveServerFromDB.bat Script on Publisher

Run RemoveSubscription.bat Script on Subscriber

Remove Redundant DCD Replication Agreements

Contents of the RemoveServerFromDB.bat Script File

Contents of the RemoveSubscription.bat Script File

Removing a Subscriber Server from Cisco CallManager

You delete a subscriber server from the Cisco CallManager cluster by using the Server Configuration window in Cisco CallManager Administration. This deletion, however, deletes the server from the Cisco CallManager Administration database, but not all of the server dependencies get deleted.

To fully delete a server from the system, you must perform the following steps:

1. Remove all dependencies from the server; for example, delete the Cisco CallManager service. See the "Deleting a Server" section.

Tip To view the dependencies, click the Dependency Records link on the Server Configuration window.

2. Remove the server from Cisco CallManager Administration. See the "Deleting a Server" section.

3. Run a script file that removes the SQL replication information from the database. See the "Remove SQL Replication Information" section.

4. Run a script file that removes the DCD replication agreements from the publisher if Cisco CallManager cluster is integrated with local DCDirectory. See the "Remove Redundant DCD Replication Agreements" section.

Remove SQL Replication Information

After the server is removed by using Cisco CallManager Administration, run the script file to remove the SQL replication information. Run the appropriate script file for the publisher and for the subscriber server.

Tip Copy the script file contents of Example B-1 and Example B-2 to a Notepad file and save it with a .bat extension; for example, removesubscription.bat and removeserverfromDB.bat.

Run RemoveServerFromDB.bat Script on Publisher

Execute the RemoveServerFromDB.bat script file from the Cisco CallManager publisher server for the cluster containing the subscriber that you want to remove. This script runs from the command prompt from any directory.

Tip To view the procedure that runs the script, run the script with no parameters.

From any directory on the publisher server, enter the following command:

<path where you saved the script>:\RemoveServerFromDB "server" "database" "name_of_server_to_delete_from_database connection string"

Tip To find the database connection string name, go to Service > Service Parameters, choose Cisco Database Layer Monitor, click Advanced, and get the name from the Database Connection String field; for example, DSN=CiscoCallManager;Server=ABC2.

When this command gets run from the command prompt, errors display; no separate error log file gets generated.

To view the contents of the script file, see the "Contents of the RemoveServerFromDB.bat Script File" section.

Run RemoveSubscription.bat Script on Subscriber

Execute the RemoveSubscription.bat script file from the Cisco CallManager subscriber server that you want to remove. This script runs from the command prompt from any directory.

Tip To view the procedure that runs the script, run the script with no parameters.

From any directory on the subscriber server, enter the following command:

<path where you saved the script>:\RemoveSubscription "server" "database"

When this command runs from the command prompt, errors display; no separate error log file gets generated.

To view the contents of the script file, see the "Contents of the RemoveSubscription.bat Script File" section.

Remove Redundant DCD Replication Agreements

After the subscriber server is removed from the cluster, clean its DCD replication information from the publisher DCD by running the clean_publisher script. The script file only executes on the publisher server.

You can access the script on Cisco CallManager release 3.3 and above. It gets installed on the Cisco CallManager server during installation of Cisco Directory component.

From any directory on the publisher server, enter the following command:

c:\Clean_publisher.cmd

The script file removes the replication agreements to all nonexistent subscribers from the publisher DCD. It does not delete or modify existing data.

Note If administrator removes the server without running the Clean_publisher.cmd script and then adds the server back with the same host name into the same cluster from where it was removed, the DCD script that is used to configure the subscriber DCD will clean up the previous DCD replication agreement from the publisher DCD database during the Directory installation of the Cisco CallManager installation on the server.

Contents of the RemoveServerFromDB.bat Script File

Example B-1 displays the contents of the script file that removes the SQL replication information from the publisher server.

Example B-1 Script File Contents
@echo off 
@if "%3x" == "x" goto Usage 
echo Install stored procedure in database %2 
echo USE %2 > temp.sql  
echo GO >> temp.sql       
echo sp_dropsubscription @publication = %2, @subscriber = '%3', @article='all' >> temp1.sql 
echo GO >> temp1.sql 
osql -S %1 -d %2 -E -e -i temp1.sql  
del temp1.sql 
goto endd                                                                                                                       
:Usage 
@echo Usage:   RemoveServerFromDB "server" "database" 
"name_of_server_to_delete_from_ProcessNode.Name"  
@echo Example: RemoveServerFromDB . CCM0300 fred.cisco.com  
:end
Contents of the RemoveSubscription.bat Script File

Example B-2 displays the contents of the script file that removes the SQL replication information from the subscriber server.

Example B-2 Script File Contents
@echo off 
@if "%2x" == "x" goto Usage 
echo Install stored procedure in database %2 
echo sp_removedbreplication @dbname = %2 > temp1.sql 
echo GO >> temp1.sql 
osql -S %1 -d %2 -E -e -i temp1.sql 
del temp1.sql 
goto endd                                                                                                                                          
:Usage 
@echo Usage:   RemoveSubscription "server" "database"  
@echo Example: RemoveSubscription . CCM0300  
:endd 

	Cisco CallManager Administration Guide, Release 4.1(3)
	Removing a Subscriber Server from Cisco CallManager (Revised 07/25/2005)
Cisco CallManager Administration Guide, Release 4.1(3) Index Preface (Revised 07/25/2005) Introduction Server Configuration Cisco CallManager Configuration Cisco CallManager Group Configuration Date/Time Group Configuration Device Defaults Configuration Region Configuration Device Pool Configuration Enterprise Parameters Configuration Location Configuration Auto-Registration Configuration Survivable Remote Site Telephony Configuration Automated Alternate Routing Group Configuration Application Dial Rules Configuration Route Filter Configuration Time Period Configuration Time Schedule Configuration Partition Configuration Calling Search Space Configuration Route Group Configuration Route List Configuration Route Pattern Configuration (Revised 08/25/2005) Line Group Configuration (Revised 07/25/2005) Hunt List Configuration Hunt Pilot Configuration Translation Pattern Configuration External Route Plan Wizard Route Plan Report Cisco IPMA Configuration Wizard Cisco CallManager Attendant Console Configuration Annunciator Configuration Conference Bridge Configuration Media Termination Point Configuration Music On Hold Audio Source Configuration Music On Hold Server Configuration Transcoder Configuration Media Resource Group Configuration Media Resource Group List Configuration Service Parameters Configuration Call Park Pickup Group Configuration Cisco IP Phone Services Configuration Client Matter Codes (CMC) Forced Authorization Codes (FAC) Meet-Me Number/Pattern Configuration Cisco Voice-Mail Port Configuration Cisco Voice Mail Port Wizard Message Waiting Configuration Cisco Voice-Mail Pilot Configuration Voice-Mail Profile Configuration (Revised 03/31/2006) Device Configuration CTI Route Point Configuration Device Profile Configuration Device Profile Default Configuration Gatekeeper Configuration Gateway Configuration (Revised 08/25/2005) Cisco IP Phone Configuration Trunk Configuration Phone Button Template Configuration Softkey Template Configuration Generating a CAPF Report Adding a New User Searching the Global Directory Multilevel Administration Access Configuration (Revised 05/26/2006) Plugin Configuration Dependency Records Removing a Subscriber Server from Cisco CallManager (Revised 07/25/2005) Cisco Unity Voice-Mail Port Adjustments	Download this chapter Removing a Subscriber Server from Cisco CallManager (Revised 07/25/2005) Download the complete book PDF Version of Entire Book (PDF - 7 MB) Feedback Table Of Contents Removing a Subscriber Server from Cisco CallManager Remove SQL Replication Information Run RemoveServerFromDB.bat Script on Publisher Run RemoveSubscription.bat Script on Subscriber Remove Redundant DCD Replication Agreements Contents of the RemoveServerFromDB.bat Script File Contents of the RemoveSubscription.bat Script File Removing a Subscriber Server from Cisco CallManager You delete a subscriber server from the Cisco CallManager cluster by using the Server Configuration window in Cisco CallManager Administration. This deletion, however, deletes the server from the Cisco CallManager Administration database, but not all of the server dependencies get deleted. To fully delete a server from the system, you must perform the following steps: 1. Remove all dependencies from the server; for example, delete the Cisco CallManager service. See the "Deleting a Server" section. Tip To view the dependencies, click the Dependency Records link on the Server Configuration window. 2. Remove the server from Cisco CallManager Administration. See the "Deleting a Server" section. 3. Run a script file that removes the SQL replication information from the database. See the "Remove SQL Replication Information" section. 4. Run a script file that removes the DCD replication agreements from the publisher if Cisco CallManager cluster is integrated with local DCDirectory. See the "Remove Redundant DCD Replication Agreements" section. Remove SQL Replication Information After the server is removed by using Cisco CallManager Administration, run the script file to remove the SQL replication information. Run the appropriate script file for the publisher and for the subscriber server. Tip Copy the script file contents of Example B-1 and Example B-2 to a Notepad file and save it with a .bat extension; for example, removesubscription.bat and removeserverfromDB.bat. Run RemoveServerFromDB.bat Script on Publisher Execute the RemoveServerFromDB.bat script file from the Cisco CallManager publisher server for the cluster containing the subscriber that you want to remove. This script runs from the command prompt from any directory. Tip To view the procedure that runs the script, run the script with no parameters. From any directory on the publisher server, enter the following command: <path where you saved the script>:\RemoveServerFromDB "server" "database" "name_of_server_to_delete_from_database connection string" Tip To find the database connection string name, go to Service > Service Parameters, choose Cisco Database Layer Monitor, click Advanced, and get the name from the Database Connection String field; for example, DSN=CiscoCallManager;Server=ABC2. When this command gets run from the command prompt, errors display; no separate error log file gets generated. To view the contents of the script file, see the "Contents of the RemoveServerFromDB.bat Script File" section. Run RemoveSubscription.bat Script on Subscriber Execute the RemoveSubscription.bat script file from the Cisco CallManager subscriber server that you want to remove. This script runs from the command prompt from any directory. Tip To view the procedure that runs the script, run the script with no parameters. From any directory on the subscriber server, enter the following command: <path where you saved the script>:\RemoveSubscription "server" "database" When this command runs from the command prompt, errors display; no separate error log file gets generated. To view the contents of the script file, see the "Contents of the RemoveSubscription.bat Script File" section. Remove Redundant DCD Replication Agreements After the subscriber server is removed from the cluster, clean its DCD replication information from the publisher DCD by running the clean_publisher script. The script file only executes on the publisher server. You can access the script on Cisco CallManager release 3.3 and above. It gets installed on the Cisco CallManager server during installation of Cisco Directory component. From any directory on the publisher server, enter the following command: c:\Clean_publisher.cmd The script file removes the replication agreements to all nonexistent subscribers from the publisher DCD. It does not delete or modify existing data. Note If administrator removes the server without running the Clean_publisher.cmd script and then adds the server back with the same host name into the same cluster from where it was removed, the DCD script that is used to configure the subscriber DCD will clean up the previous DCD replication agreement from the publisher DCD database during the Directory installation of the Cisco CallManager installation on the server. Contents of the RemoveServerFromDB.bat Script File Example B-1 displays the contents of the script file that removes the SQL replication information from the publisher server. Example B-1 Script File Contents @echo off @if "%3x" == "x" goto Usage echo Install stored procedure in database %2 echo USE %2 > temp.sql echo GO >> temp.sql echo sp_dropsubscription @publication = %2, @subscriber = '%3', @article='all' >> temp1.sql echo GO >> temp1.sql osql -S %1 -d %2 -E -e -i temp1.sql del temp1.sql goto endd :Usage @echo Usage: RemoveServerFromDB "server" "database" "name_of_server_to_delete_from_ProcessNode.Name" @echo Example: RemoveServerFromDB . CCM0300 fred.cisco.com :end Contents of the RemoveSubscription.bat Script File Example B-2 displays the contents of the script file that removes the SQL replication information from the subscriber server. Example B-2 Script File Contents @echo off @if "%2x" == "x" goto Usage echo Install stored procedure in database %2 echo sp_removedbreplication @dbname = %2 > temp1.sql echo GO >> temp1.sql osql -S %1 -d %2 -E -e -i temp1.sql del temp1.sql goto endd :Usage @echo Usage: RemoveSubscription "server" "database" @echo Example: RemoveSubscription . CCM0300 :endd
	Terms & Conditions \| Privacy Statement \| Cookie Policy \| Trademarks