TSM DB Tables

[Demond]

I've seen this done before but I don't remember how it was done. How can I view (via the command-line) the fields available in a TSM DB table? For instance, if I wanted to run a query on a table and wanted to know what fields I can query against. Thx.

 

[nezih]

select * from tables
or select * from columns

 

[reddy]

You can also filter like

select tabname from tables (OR)
select colname from columns where tabname='TABLE-NAME-HERE'

 

[Demond]

Thanks for the quick response. That worked!

 

[Demond]

Thx

Reddy - that's even better it will allow me to be more specific in my search. Thx to you both!

 

[THE_WIPET]

look a this tread, some one did a visio of the TSM database table

http://adsm.org/forum/showthread.php?t=14040