list of tables in TSM databse?

[wirb]

Greetings everyone,



New to TSM, and I'm feeling my way around the SQL landscape. The syntax isn't difficult, but what I could really use is a way to find a list of the tables in the database. For example, I want to run a select to find out what volume are being used for archives; if I knew what table stores the list of archive volumes it would be a simple matter to find what I want. That sort of thing. Any resources y'all can point me to would be much appreciated.



TIA

 

[jimanorris]

If you have expanded the sample scripts, RUN Q_TABLES. Then to see the columns in a table RUN Q_COLUMNS tabname



If you have not expanded the scripts then you can look in SYSCAT.TABLES and SYSCAT.COLUMNS

 

[wirb]

Found it right after I posted this -- SYSCAT.TABLES



thanks!