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:

 

http://publib.boulder.ibm.com/infocenter/soliddb/v6r5/topic/com.ibm.swg.im.soliddb.admin.doc/doc/solsql.commands.html

 

Tags:  aware aix cluster soliddb solsql chris caa /opt/cluster/soliddb/bin/... gibson