Navigate
ScaleArc Customer Support
  • Login to Ignite Global Support
or
Contact Us
  • Get in touch

    Send us an email

  • Submit Feedback

    Feedback and suggestions submitted by customers like you

  • Knowledgebase Read help articles
  • Feedback Custom suggestions
  • Downloads Browse our downloads
  • Contact Us We are here to help
  • Portal
  • Knowledgebase
  • Databases
  • How to extract data regarding fetched Stored Procedures from ScaleArc Logs
Subscribe Download PDF

How to extract data regarding fetched Stored Procedures from ScaleArc Logs

Sanjay More
2017-05-29
0 Comments
in Databases

 

Release Classification Level DB Platform Categories
3.2+ Info MySQL, MSSQL

Configuration

 
1. Log into ScaleArc console using ssh.
2. change to /logs/<date>
 
3. To list all records for fetched Stored Procedures when you hit the "List Stored Procedure"
4. $ cat  idb.uilog.<date><hour> | grep -a "List of Stored procedures for selected DB" | awk -F "[" '{print $2}'
e.g.$ cat idb.uilog.2017052916 | grep -a "List of Stored procedures for selected DB" | awk -F "[" '{print $2}'
above command gave following result
{"sp_name":"AsyncSample","dbname":"mysql","sp_type":1,"sp_object_id":"AsyncSample"},{"sp_name":"dorepeat","dbname":"mysql","sp_type":0,"sp_object_id":"dorepeat"}],"total":2,"apiTimeTaken":4}}"
Look for ..
"sp_name":"AsyncSample"
"sp_type":1

 

"sp_type":0    >> Read Only

 

"sp_type":1 >> Read/Write
 

If you are experiencing issues with ScaleArc or with any of it's features, please contact ScaleArc Support. We are available 24x7 by phone at 855 800 7225 or +1 408 412 7315.

For general support inquiries, you can also e-mail us at support@scalearc.com.

Copyright ©2014 ScaleArc, Inc. All rights reserved. Contact Support |  Contact ScaleArc |  Feedback

2901 Tasman Drive Santa Clara, CA 95054 | Email:  support@scalearc.com

Permalink: https://support.scalearc.com/kb/articles/4327

Rate the quality of this page

This page was helpful :) :( This page was not helpful

7 of 13 people found this page helpful


Quick Jump
  • ScaleArc Customer Support
  • Knowledgebase
  • Downloads
  • Feedback
  • Contact Us
Top
Helpdesk software provided by DeskPRO