How to access SUP Cluster DB?
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.
- SUP 2.x
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
Note: For more details check this Wiki Page.
I hope this document will help you.
Your comments/Suggestions are most welcome.