ADSM-L

Re: TSM Database Tables

2002-02-15 16:06:51
Subject: Re: TSM Database Tables
From: 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 queried with the SELECT
command.
SYSCAT.COLUMNS
Describes the columns in each table.
SYSCAT.ENUMTYPES
Defines the valid values for each enumerated type and the order of the values
for each type.
For example, to get a list of all tables available for querying in the 
database, enter the
following command:
select * from syscat.tables


<Prev in Thread] Current Thread [Next in Thread>