Interview question: Cisco Voice Engineer: CUCM Database replication value, do you know what you are talking about?

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

Value Meaning Description
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.

Source: CCO

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.





SQL Lessions – 1. Download and install

About 2 years ago, I bought a SAM’s quickie learning series book on SQL but it was sitting in the bookshelf and never been used. I am going to FORCE myself to learn and understand a little about SQL, and hopefully, on the way, I can share the documentation and learning with others. SQL, Sequel, Structured Query Language, however you call it, as an Engineer, you will come across it and hear about it as the current trend is all on Cloud and Big Data technologies. Behind the Cloud technology is powerful data centers with super computers and network devices. In the same Data Center, the Big Data reside on these servers, they live on virtual servers and SAN. The applications using these Big Data technologies are SQL apps [Oracle, IBM Infomix, MS-SQL, MySQL]. So, it is inevitable that you should make an effort to understand a little bout SQL I will be using free software called MySQL installed on Windows 7 laptop. Please find the installation steps to begin our journey into SQL: Step 1: Go to and download the latest mysql version mysql1 mysql2 Step 2: Extract the zip file to C:\ mysql3 mysql4 Step 3: Once the files are fully extracted, rename the folder to ‘mysql’ mysql5 mysql6 Step 4: Go to Computer > Properties > Advanced system settings > Environment Variables > Under System variables, find ‘Path’, then Edit > add “;C:\mysql\bin” mysql8 mysql9 mysql10 mysql11 mysql12 Step 5: Open command line as administrator mysql13 Step 6: Change the folder to mysql/bin folder and run ‘mysqld –install’ command to complete the installation mysql14 Step 7: Open services or services.msc as administrator mysql15 Step 8: Locate ‘MySQL’ service and start the service mysql16 Step 9: Now open Command Line and go down to C:\mysql\bin and start mysql mysql17 Now you are ready for your lesson 2. Let’s take one lesson at a time and slowly. Do you guys like potato chips? I DO! and I find slow cooked chips taste better. 🙂