How to collect dump of registry keyspace in TIBCO Cloud API Management-Local Edition

Products	Versions
TIBCO Cloud API Management - Local Edition	5.x and above

Description

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.

Issue/Introduction

This article provides inputs on how to collect dump of registry keyspace using Cassandra/NoSQL query language in Cassandra/NoSQL pod for the APIM-LE.

Environment

ALL

Resolution

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.

Additional Information

Keyspace, registry, cassandra, NoSQL, dumps, tables

Attachments

How to collect dump of registry keyspace in TIBCO Cloud API Management-Local Edition get_app

Welcome to "KB Articles"