How to access SUP Monitoring DB?

[Jitendra_Kansal]

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 :

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.

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01205.0222/doc/html/aba12...

Note: For more details check this Wiki Page.

I hope this document will help you.

Your comments/Suggestions are most welcome.

 

Regards,

Jitendra Kansal