Skip to Content
Author's profile photo Jitendra Kansal

How to access SUP Monitoring DB?

Dear All,
OBJECTIVE:
This Document explains steps how to access SUP monitoring database schema. This contains a set of tables from which information is retrieved.
REQUIREMENT:
  • SUP 2.x
Procedure:
Assuming that you have created MBO(s) and deployed successfully to SUP server. then the same package has been implemented with client side application.
once you run the application on device, data starts flooding in tables under monitoring database.
For accessing Monitoring DB, a tool is available.
Finding Out the path for Monitoring DB Tool:
  • go to the location: C:\Sybase\UnwiredPlatform\Servers\SQLAnywhere12\Bin32
  • look for dbisql.exe
Capture.PNG
  • For ODBC Data Source name, click on Browse, search for monitordb_32bit

 

    • Pass User ID: dba
    • Password: sql
    • Click on Connect 
Capture.PNG
list of tables can be found at :
  1. mms_rbs_request
  2. mms_rbs_request_summray
  3. mms_rbs_mbo_sync_info
  4. mms_mbs_message
  5. mms_security_access
  6. mms_rbs_outbound_notification
  7. mms_concurrent_user_info
  8. mms_queue_info
  9. mms_sampling_time
  10. cache_history
  11. cache_statistic
you can access these above tables from monitoring tool by running a simple object query.
select * from table name
Summary history information is available at below link.
Note: For more details check this Wiki Page.

I hope this document will help you.

Your comments/Suggestions are most welcome.

 

Regards,

Jitendra Kansal

Assigned tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good Work Jitendra!!

      Keep them coming.

      Regards,

      Akhil

      Author's profile photo Vikas Singh
      Vikas Singh

      I'll second Akhil - definitely useful information .

      Thanks

      Vikas

      Author's profile photo Jitendra Kansal
      Jitendra Kansal
      Blog Post Author

      Thanks Vikas !!!

      Author's profile photo Jitendra Kansal
      Jitendra Kansal
      Blog Post Author

      Thanks Akhil !!!