HI Kunal - documentation on the SQL interface is available in the latest
versions of the manual, ADSM Administrator's Guide (available in softcopy
for download from the ADSM website, http://www.storage.ibm.com/adsm - click
on Product details) and in the redbook (acccess at
http://www.redbooks.ibm.com) ADSM V3 Technical Guide.
Basically, syscat.tables lists all the tables in the ADSM db, and
syscat.columns specifies the columns in each table.
So, if you do
adsm> select TABNAME, REMARKS from syscat.tables
you get a list of all the tables.
To list the columns in a particular table,
adsm> select COLNAME, REMARKS from syscat.columns where tabname='LOG'
or tabname='NODES' or whatever table you're interested in.
Then you can use this information to start querying the actual tables
themselves. The doco has some sample SQL queries to get you started, and if
you are at ADSM server V3.1.2, check out the new server scripts which have
a number of other sample queries.
The other table, syscat.enum has info on the values for special data types.
Hope this helps ..

Regards,
Charlotte
Email: cbrooks AT au1.ibm DOT com
Ph: 61-2-9353-3437, Fax 61-2-9353-3496, Mobile: 0411-117-538
AP ADSM Technical Support Manager