I can not find the sample scripts on my W2K Server. Does anyone know where I would find these samples for Windows servers. Al ----- Original Message ----- From: "Joerg Pohlmann/CanWest/IBM" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 17, 2002 1:50 PM Subject: Re: TSM Database Tables
> 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@[EMAIL PROTECTED]> on 2002-02-15 12:57:01 > > Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > > To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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 <[EMAIL PROTECTED]> > Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > 02/15/2002 13:40 > Please respond to "ADSM: Dist Stor Manager" > > > To: [EMAIL PROTECTED] > 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
