Author: Hussein Abdirahman <hussein.abdirahman AT IRWINTOY DOT COM>
Date: Tue, 24 Sep 2002 12:22:07 -0400
Hi All; An easy one perhaps but I would like to know How can I find out all the TSM table names? TIA regards; Hussein A. Hi *smers, I have a strange problem for me. We deleted the data from a volume
Author: "Mark D. Rodriguez" <mark AT MDRCONSULT DOT COM>
Date: Tue, 24 Sep 2002 11:29:41 -0500
Hi All; An easy one perhaps but I would like to know How can I find out all the TSM table names? TIA regards; Hussein A. Hi *smers, I have a strange problem for me. We deleted the data from a volume
select tabname from syscat.tables Hi All; An easy one perhaps but I would like to know How can I find out all the TSM table names? TIA regards; Hussein A. --Original Message-- From: Sam Haziprodromu
Author: Andrew Raibeck <storman AT US.IBM DOT COM>
Date: Fri, 15 Feb 2002 15:57:01 -0500
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
Author: "PINNI, BALANAND (SBCSI)" <bp3965 AT SBC DOT COM>
Date: Fri, 15 Feb 2002 14:58:25 -0600
Hi There is a way that view holds.All Base tables names are stored in view. I feel u need to look at view using select statements on line . I will mail if I find it. Balanand Pinni
Author: Doug Thorneycroft <dthorneycroft AT LACSD DOT ORG>
Date: Fri, 15 Feb 2002 13:02:54 -0800
(From the ADMIN GUIDE) To help you find what information is available in the database, TSM provides three system catalog tables: SYSCAT.TABLES Contains information about all tables that can be querie
Author: Andrew Raibeck [mailto:storman AT US.IBM DOT COM]
Date: Sun, 04 Oct 2015 17:12:13 -0500
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
Author: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Fri, 15 Feb 2002 20:42:20 -0500
Actually, this will give you all the columns of all the tables, a big list. You may want to look at what tables there are first, then add a "where tabname = 'thetable'" to the end of what Bill sugges
Author: Joerg Pohlmann/CanWest/IBM <jpohlman AT CA.IBM DOT COM>
Date: Sun, 17 Feb 2002 13:50:36 -0800
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