Tsm sql tables

[influx]

Does IBM officially support the information in the SQL tables? Is it considered a valid data source? What is IBM's official position on the integrity of the data in the SQL tables.

 

[Samuel]

What is your version of TSM ? if you have tsm 5.5 :
SELECT (Perform an SQL query of the IBM Tivoli Storage Manager Database)
Use this command to create and format a customized query of the IBM
Tivoli Storage Manager database. On IBM Tivoli Storage Manager, this
command uses a subset of the SQL92 and SQL93 standards.
The SELECT command is consistent with most relational database access
products, such as LOTUS 1-2-3® and Microsoft Access. It presents server
information in the form of relational tables containing rows (records)
and columns (fields).
To help you find what information is available, IBM 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 type and the ordering of
those values for columns that have an enumerated data type
(SQL93).

 

[cjhood]

Does IBM officially support the information in the SQL tables? Is it considered a valid data source? What is IBM's official position on the integrity of the data in the SQL tables.

I would assume so. You're getting the data straight out of the TSM DB when you do a select, if you can't trust it then you can't trust your DB or anything in TSM for that matter.

Ask IBM for their official position. Then you'll know for sure