95
Did you know that you can connect to and query the new solidDB database used by Cluster Aware AIX (CAA)?
You can connect to the solidDB instance and issue SQL queries against the database. In the following example, I issued two queries: one to list the tables in the database and another to query information relating to the nodes in the cluster. The formatting in the second query is a mess, but you get the idea.
root@node1:/> /opt/cluster/solidDB/bin/solsql -x pwdfile:/etc/cluster/dbpass 'tcp localhost 2188' caa
IBM solidDB SQL Editor (teletype) - Version: 6.5.0.3 Build 2010-10-04
(c) Solid Information Technology Ltd. 1993, 2010
Connected to 'tcp localhost 2188'.
Execute SQL statements terminated by a semicolon.
Exit by giving command: exit;
list tables;
RESULT
------
Catalog: CAA
Schema: CAA
TABLES:
-------
CLUSTERS
NODES
REPOSNAMESPACE
REPOSSTORES
SHAREDDISKS
INTERFACES
INTERFACE_ATTRS
PARENT_CHILD
ENTITIES
1 rows fetched.
select * from clusters;
CLUSTER_ID CLUSTER_NAME ETYPE ESUBTYPE GLOB_ID UUID VERIFIED_STATUS ESTATE VERSION_OPERATING VERSION_CAPABLE MULTICAST
---------- ------------ ----- -------- ------- ---- --------------- ------ ----------------- --------------- ---------
1 SIRCOL_UNKNOWN 4294967296 32 4294967297 00000000-0000-0000-0000-000000000000 NULL 1 1 1 0
2 node2 4294967296 32 4294967296 4145b106-a7ab-11e0-bb35-00145e5286d0 NULL 1 1 1 0
2 rows fetched.
exit
quit;
IBM solidDB SQL Editor exiting.
root@node1:/>
The new Redbook on IBM PowerHA 7.1 SystemMirror for AIX has some more information on and examples of using the solsql tool in a PowerHA 7.1 (with CAA) environment. Refer to section 8.3.2 CAA commands and log files:
http://www.redbooks.ibm.com/abstracts/sg247845.html?Open
You can find more information on the solsql command here:
