Storage Management

Simplifying and automating management of the storage initiatives.

Topics and products covered may include: IBM Tivoli Storage Manager family, IBM Total Storage Productivity Center and more.

>> 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