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:
You would have checked How to access SUP CDB (Cache Database) ?
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
- For ODBC Data Source name, click on Browse, search for monitordb_32bit
-
- Pass User ID: dba
- Password: sql
- Click on ConnectÂ
list of tables can be found at :
- mms_rbs_request
- mms_rbs_request_summray
- mms_rbs_mbo_sync_info
- mms_mbs_message
- mms_security_access
- mms_rbs_outbound_notification
- mms_concurrent_user_info
- mms_queue_info
- mms_sampling_time
- cache_history
- 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
Good Work Jitendra!!
Keep them coming.
Regards,
Akhil
I'll second Akhil - definitely useful information .
Thanks
Vikas
Thanks Vikas !!!
Thanks Akhil !!!