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

+

• 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