How to access SUP Cluster DB?

[Jitendra_Kansal]

Hi All,

 

OBJECTIVE:

 

There are different type of database availble at SUP (Sybase Unwired Platform) side like SUP cache, SUP monitoring DB, Cluster DB. This Document explains steps how we can access cluster based information from database.

 

REQUIREMENT:

 

• SUP 2.x

 

Procedure:

 

You would have checked

How to access SUP CDB (Cache Database) ?

How to access SUP Monitoring DB?

 

For accessing ClusterDB, a tool is available. This tool is same for SUP cache, Montoring DB, Cluster DB.

 

Finding Out the path for Cluster 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 clusterdb_mysupcluster_32bit

 

• 
  
  
  
  • Pass User ID: dba
  
  
  • Password: sql
  
  
  • Click on Connect
  
  
  
  

 

 

This database contains list of tables which has different information.

 

e.g.  1. there is a table called SLD_SUPSERVER_INFO

 

when you execute this table by select * from SLD_SUPSERVER_INFO

 

it will give you server information like what is server name, what is the installation path for the same sup server etc.

 



2. another table , RELAY_SERVER

it will give you relay server information (asssuming relay server has been installed for that SUP server) like relay server host name, port no, URL etc.

 



 

 

3. You can also check which SUP node is a primary one by running a join query like:

 

SELECT x.CLUSTERID,x.name, y.name , x.LEASEEXPIRES

FROM CLUSTER_RESOURCE x, Cluster_member y where x.OWNER = y.MEMBERID

 

 

It is not possible to share all tables' screenshots.so here i am listing down all the tables name available in this cluster database.

 

you can access these tables from the tool by running a simple object query.

select * from table name

 

1. async_queue_prop


2. BACKEND_FARM


3. BACKEND_SERVER


4. cache_addr_mapping


5. cache_config


6. CLUSTER


7. CLUSTER_INSTALLATION


8. CLUSTER_MEMBER


9. CLUSTER_PROP


10. CLUSTER_RESOURCE


11. djc_pc


12. endpoint_prop


13. ENTITY_TYPE


14. FARM_AND_PORT_TYPE


15. MEMBER_PROP


16. RELAY_SERVER


17. RELAY_SERVER_HTTP_CREDENTIAL


18. RSOE


19. RSOE_PROXY


20. RSOE_PROXY_USER


21. SLD


22. SLD_SUPSERVER_INFO


23. SUP_APNS_CONFIG


24. SUP_BES_CONFIG


25. SUP_BIS_CONFIG


26. SUP_GCM_CONFIG


27. SUP_PUSH_CONFIG


28. SUP_SERVER_PORT


29. SUP_PUSH_CONFIG


30. SYNC_DATA

 

Note: For more details check this Wiki Page.

 

I hope this document will help you.

Your comments/Suggestions are most welcome.

 

Regards,

Jitendra Kansal