How do I check CLM database synchronization?

Purpose

Perform this procedure to check the synchronization status of the database instances in the redundant CLM clusters of a DR deployment. You can check the synchronization status from the CLM UI, or using a CLI.

Steps
Check database synchronization from the CLM UI
 
1 

As a CLM administrator, choose System Health from the CLM menu.

2 

View the information in the Database Synchronization Status panel, which lists the synchronization completion percentage for postgres—PostgreSQL database.

To view expanded details for a database, click png11.png View on the list item.

End of steps

Steps
Check database synchronization using a CLI
 
1 

Log in as the root or CLM admin user on the CLM cluster host in the primary data center.

2 

Open a console window.

3 

Enter the following:

# kubectl exec -n $(kubectl get pods -A | awk '/nspos-asm/ {print $1;exit}') -it $(kubectl get pods -A| awk '/nspos-asm/ {print $2;exit}') -c nspos-asm-app -- /opt/nsp/os/asm/bin/report.py ↵

4 

Database synchronization data is returned in the following format:

{

"message": "Data retrieved",

"data":

[

{

"dcName": "string",

"dbName": "string", // postgres|neo4j

"podName": "string",

"role": "string", // PRIMARY|STANDBY for postgres, LEADER|FOLLOWER|READ_REPLICA for neo4j

"activeSize": "string",

"sizeUnit": "string", // Bytes for postgres, Commits for neo4j

"isInRecovery": null, // or boolean for postgres

"isReplayPaused": null, // or boolean for postgres

"receivedSize": null, // or string for postgres

"replaySize": null, // or string for non primary/leader instances

"lastReplayTimeStamp": null, // or timestamp string for postgres

"missingSize": null, // or string for non primary pg instances

"dataToTransfer": null, // or string for non primary pg instances

"dataToProcess": null, // or string for non primary/leader instances

"syncPercentage": double // real number 0-100

},

],

"status": "success"

}

5 

Review the information.

6 

Close the console window.

End of steps