Tsm5.5 sql = tsm6.1 sql?

[micha]

Hello,

while completely rewriting TSM Monitor to store all queried data into a seperate database I wondered if the database/table layout of TSM6.1 is still the same? Do my old queries will work? I don't hava a test server yet

Thanks,
Micha

 

[SpiritSoftware]

Sql 5 - 6

This is my experience between version 5.5 and 6.1 over the past couple of weeks

If you are doing all your queries through the admin client you should be okay except if you are using the catalog tables syscat.tables and syscat.columns as in version 6.1 the TSM Internal tables are no longer in the catalog ( such as AUDITOCC and STATUS ) though you can still run select statements against them

Even though IBM states that the ODBC driver is no longer supported it still appears to work though a number of data types in some of the tables have changed

I have managed to get the ODBC driver for DB2 working and started doing some comparisions and I have found a number of new tables that I am still working through. It would help if IBM published the schema and purpose of each table as well as provide access to the admin api

Graeme

 

[micha]

Sounds good, thanks I am using dsmadmc so it should be ok.

 

[unclesam_jo]

Customization of Operational Reporting for use with TSM 6

Hello Every one ..
check this

http://www.ibm.com/developerworks/f...onal Reporting for use with TSM 6 rev 1.0.doc


This document shows how to customize default reports and monitors in TSM 5.5.3 Operational Reporting to make them work with a TSM 6.1 server.
Its very useful , no need to get any third party tools !!!
Test it ,, good luck