Skip to Content
Author's profile photo Jitendra Kansal

How to access SUP Cluster DB?

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

 

1.PNG+

 

 

  • For ODBC Data Source name, click on Browse, search for clusterdb_mysupcluster_32bit

 

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

1.PNG

 

 

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.

 

1.PNG

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.

 

1.PNG

 

 

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.