Even better is to install the sample scripts. Shut down your server, then
do a dsmserv runfile /usr/tivoli/tsm/server/webimages/scripts.smp if your
server is on AIX (on other platforms the file is in the appropriate
directory/data set/minidisk - if you cannot find it, I'll be glad to send
it to you). Then restart your server and all you need to do is run Q_TABLES
to get a nicely formatted list of tables. My second favourite script is to
"run Q_COLUMNS <tablename>"  to get the columns in a table. Many thanks to
the developer in TSM who provided this sample set. There are many other
useful examples in this set of sample scripts that have helped me with SQL
SELECT statements.

Joerg Pohlmann



Andrew Raibeck/Tucson/IBM@IBMUS AT VM.MARIST DOT EDU> on 2002-02-15 12:57:01

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:    "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:    ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:    Re: TSM Database Tables


Hi Pattie,

I"m not aware of any updated list, but you can use the SELECT statement to
find out:

   SELECT TABNAME FROM TABLES

You can use the following to find out what columns are in the table:

   SELECT * FROM COLUMNS WHERE TABNAME='tablename'

where tablename is the name of the table you are interested in (be sure to
put the table name in uppercase).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Patricia LeBlanc <Patricia.Leblanc AT LIBERTYMUTUAL DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
02/15/2002 13:40
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        TSM Database Tables



Anyone know where I can find (online) an updated copy of the TSM Database
Tables?

Thanks,
pattie
Liberty Mutual
Backup and Recovery