|
|
Browse by categories | Browse by alphabetical list
| Server, Network & Device Management (Systems Management) Storage Management >> Tivoli Storage Manager
ITSM uses pre coded SQL statements to query the ITSM database to find any information you may need. Custom SQL statements can be created if
need be to create different reports or views.
To help you find what information is available in the database, Tivoli Storage Manager 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.
You can issue the SELECT command to query these tables to determine the location of the information that you want. For example, to get a list of all tables available for querying in the database, enter the following command:
select * from syscat.tables
>> All or Other Storage Management Products
>> Tivoli Continuous Data Protection For Files
Security Management Business Application Management z/OS Systems Management Asset Management |
|
Email this to a friend
Del.icio.us
Digg