CUCM Checking Replication Status

Author
William Bell
Vice President, Solutions and Products

Back in my day …

The folks who worked with CUCM database replication issues remember the days when we were able to use SQL enterprise manager or the dblhelper application with its silly little smiley faces. I hated dblhelper but I missed it when trying to check database replication on 5.0 and 5.1 builds.

{readmore}On these builds, the only option was to do the following:

1. At the console or SSH terminal execute “utils dbreplication status” and let it run for a few minutes. Then use “file view activelog cm/trace/dbl/” and scroll through a ton of output to make sure all table counts across all CUCM nodes lined up. Yeah, fun.

2. Use RTMT (or a very long command on the console) to look at the Replicate_state performance counter to make sure the replicate state was a “2” for all devices. Not as bad but still tedious because you have to check each server (if using the SSH or console session) or load counters into RTMT from each server. From a time perspective, you might as well do both steps 1 and 2.

I found out recently from checking an image I have in the lab that CUCM 6.0 has the same “issues” as 5.0 and 5.1(2).

With 5.1(3), 6.1(x), and 7.x  we now have some better methods to get at this information by using Cisco Unified Reporting Tool. Since it is Unified it must be great. Anyway, I checked out the tool mainly because I wanted to see if my customer was hit by a cosmetic defect in the reporting tool (hmmm, not so great). The tool was not affected by the defect (Yay!) and I found that it provides detailed information quickly.

For those interested:

  1. Go to https://<yourpublishernode>/ccmadmin and logon
  2. From the Navigation drop down list, choose “Cisco Unified Reporting”
  3. You are sent to a new page, on the left click on “System Reports” to drop down the menu
  4. Select “Unified Database Status”
  5. If someone has ran a report in the past, you will see a link to the report in the main page. If you choose this link you will see an “older” report.  To generate a new report you must click on the bar graph icon in the top right of your screen. 
  6. When generating a new report, the main screen will show a progress bar
  7. After the report is completed you can view the following to get an idea on replication health:
    1. Unified CM Database Access
    2. Unified CM Database Status

 

For the folks who prefer to use RTMT, there is a Database summary tool that pretty much provides a single view of replication status.

 

Posted Jul 30, 2008, 10:36 PM by wjb

Leave a Reply

 

Nick Kelly

Cybersecurity Engineer, Cisco

Nick has over 20 years of experience in Security Operations and Security Sales. He is an avid student of cybersecurity and regularly engages with the Infosec community at events like BSides, RVASec, Derbycon and more. The son of an FBI forensics director, Nick holds a B.S. in Criminal Justice and is one of Cisco’s Fire Jumper Elite members. When he’s not working, he writes cyberpunk and punches aliens on his Playstation.

 

Virgilio “BONG” dela Cruz Jr.

CCDP, CCNA V, CCNP, Cisco IPS Express Security for AM/EE
Field Solutions Architect, Tech Data

Virgilio “Bong” has sixteen years of professional experience in IT industry from academe, technical and customer support, pre-sales, post sales, project management, training and enablement. He has worked in Cisco Technical Assistance Center (TAC) as a member of the WAN and LAN Switching team. Bong now works for Tech Data as the Field Solutions Architect with a focus on Cisco Security and holds a few Cisco certifications including Fire Jumper Elite.

 

John Cavanaugh

CCIE #1066, CCDE #20070002, CCAr
Chief Technology Officer, Practice Lead Security Services, NetCraftsmen

John is our CTO and the practice lead for a talented team of consultants focused on designing and delivering scalable and secure infrastructure solutions to customers across multiple industry verticals and technologies. Previously he has held several positions including Executive Director/Chief Architect for Global Network Services at JPMorgan Chase. In that capacity, he led a team managing network architecture and services.  Prior to his role at JPMorgan Chase, John was a Distinguished Engineer at Cisco working across a number of verticals including Higher Education, Finance, Retail, Government, and Health Care.

He is an expert in working with groups to identify business needs, and align technology strategies to enable business strategies, building in agility and scalability to allow for future changes. John is experienced in the architecture and design of highly available, secure, network infrastructure and data centers, and has worked on projects worldwide. He has worked in both the business and regulatory environments for the design and deployment of complex IT infrastructures.