Go to:

www.redbooks.ibm.com

Search:  SG24-6554

Tivoli Storage Manager 5.1 Technical Guide

APPENDIX A explains all about using SQL SELECT to search the TSM DB.
It also explains how to get a list of the TSM tables and columns.

select * from syscat.tables
select * from syscat.columns


(But it is not a DB2 data base).

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Slawomir Ksiazek
Sent: Thursday, November 17, 2005 3:24 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: How to check


Hi
I am looking for data base schema TSM (DB2),Please help me.
Thanks

Slawek





----- Original Message -----
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
To: <ADSM-L AT VM.MARIST DOT EDU>
Sent: Thursday, November 03, 2005 6:42 PM
Subject: Re: [ADSM-L] How to check


Do you want to know if a particular file is backed up?

Or do you want to know exactly which VOLUME contains the file?


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Slawomir Ksiazek
Sent: Wednesday, November 02, 2005 5:39 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: How to check


Hi
First , i am sorry for my poor english.
How to check sql command or am file XY in pool Z

Thanks

                                                    Slawek