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

 

---

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