This article has details on how to use the Cassandra/NoSQL query language on an APIM-LE setup to collect the registry keyspace dumps which would help us to troubleshoot issues at the database level and would help us verify if the issue is on keyspace level or not.
 

Go to the Cassandra pod/NoSQL Pod or container and execute the command "cqlsh". Following is a code snippet that provides an example of using cqlsh and other commands to collect dumps from "tmg_registry":

After executing "cqlsh command", run the below commands to collect dumps from "tmg_registry":

cqlsh> use tmg_registry;


cqlsh:tmg_registry> describe tables;

zones           platformapi_nodes  oauth_settings  log_nodes
nosql_settings  cache_nodes        clusters        sql_nodes
nosql_nodes     sql_settings       cm_nodes        platformapi_settings
cm_settings     tm_settings        tm_nodes
cache_settings  log_settings       oauth_nodes


cqlsh:tmg_registry> COPY zones TO '/tmp/zones.csv' with HEADER=TRUE;

Similarly, perform the above steps for all tables present under "tmg_registry" and provide it to the Support Engineer on the ticket. Attached a screenshot for reference using "zones" and "cache_nodes" table.