Querying the Cluster Aware AIX solidDB database.
cggibbo 270000TMUJ Visits (12375)
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.
IBM solidDB SQL Editor (teletype) - Version: 188.8.131.52 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;
1 rows fetched.
select * from clusters;
2 rows fetched.
IBM solidDB SQL Editor exiting.
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:
You can find more information on the solsql command here: