Skip to Content
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

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply