> 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