Issue with JDBC connection on CA API GW

Products

• CA API Gateway
• API SECURITY
• CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)
• CA API Gateway Enterprise Service Manager (Layer 7)
• STARTER PACK-7
• CA Microgateway

Issue/Introduction

We have CA API GW 9.4 CR 04 RHEL appliance in our environment. We are connecting to MYSQL of CA API GW from policy manager using JDBC connections. We are executing "show slave status" query from JDBC connection. However we are getting zero rows in result

 

Environment

Release : 9.4

Component : API GATEWAY

Resolution

What we determined is the call “show slave status” is not a query to a table it’s a function call to check the status JDBC query will only return 0 or -1.  Nothing is returned l because there is no table data

It suggested to use ssg/ping if possible it returns the replication status note also many other gateway status