Database latency check in Service Catalog

Products

• CA Service Catalog

Issue/Introduction

How to check the Database latency from Service Catalog server?

Environment

Release : 17.x

Resolution

The getDBConnectionStatus method from soap web service can be used

1.Download SOAP UI or similar tool. URL https://www.soapui.org/downloads/soapui/

2. Click on SOAP icon > Set a project name > Add the following to Initial WSDL: http://<HOST>:<PORT>/usm/services/AdministratorService?wsdl

3. Run: 

<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://services.soap.usm.ca.com">
   <soapenv:Header/>
   <soapenv:Body>
      <ser:getDBConnectionStatus soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"/>
   </soapenv:Body>
</soapenv:Envelope>

If the result is more than 10 means there is a DB latency.

Example: