You can use a standard SQL SELECT statement to get information from the database.
IBM® Tivoli® Storage Manager Versions 6.1 and later use the DB2® open database connectivity (ODBC) driver to query the database and display the results.
DB2 provides its own ODBC driver which can also be used to access the Tivoli Storage Manager server DB2 database. For more information on the DB2 native ODBC driver, refer to DB2 documentation at: http://pic.dhe.ibm.com/infocenter/db2luw/v10r5. Search on Introduction to DB2 CLI and ODBC