This is a helpful reminder note for all who manages CUCM on day-to-day basis and one of the favorite Voice/IPTel Engineer interview questions. I think I was asked this question in almost every voice Engineer role interviews. Good luck with your next interview!
Q1. What does CUCM database replication value mean to you (CM Administrator)?
2 = Good, excellent, no behind pain
Other than 2 = Behind pain begins
|0||Initialization State||This state indicates that replication is in the process of trying to setup. Being in this state for a period longer than an hour could indicate a failure in setup.|
|1||Number of Replicates not correct||This state is rarely seen in 6.x and 7.x but in 5.x can indicate its still in the setup process. Being in this state for a period longer than an hour could indicate a failure in setup.|
|2||Replication is good||Logical connections have been established and tables match the other servers on the cluster.|
|3||Tables are suspect||Logical connections have been established but we are unsure if tables match.
In 6.x and 7.x all servers could show state 3 if one server is down in the cluster.
This can happen because the other servers are unsure if there is an update to a user facing feature that has not been passed from that sub to the other device in the cluster.
|4||Setup Failed / Dropped||The server no longer has an active logical connection to receive database table across. No replication is occurring in this state.|
Q2. How to check?
Option 1: On CUCM OS CLI, run show command
admin:show perf query class “Number of Replicates Created and State of Replication”
==>query class :
– Perf class (Number of Replicates Created and State of Replication) has instances and values:
ReplicateCount -> Number of Replicates Created = 427
ReplicateCount -> Replicate_State = 2 <<< Life is Good
Option 2: On CUCM Unified Reporting
Cisco Unified Reporting > System Reports > Unified CM Database Status >> Run report
Option 3: Real Time Monitoring Tool (RTMT)
Install RTMT plugin on your desktop. Launch RTMT and then go to “Call Manager > Service > Database Summary”
Q3. How to repair a broken db replication issue?
I have come acorss a very good blog and it shows you on how to repair a broken db replication. Click here.