CA API GatewayAPI SECURITYCA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)CA API Gateway Enterprise Service Manager (Layer 7)STARTER PACK-7CA 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 from this call because there is no table for the data
It suggested to use ssg/ping if possible it returns the replication status note also many other gateway status