Finding a tape with a certain backed up file

[umbletech]

Hi All

TSM newb. I have to be able to restore mailboxes maybe from weeks ago which means restoring the particular exchange database. They're stored offsite so I need to know what tapes to bring back. So I have a specific file say vs1-mb1.edb which will have backed up from a specific client node - vs1 on a certain date.

Can anyone help me with a starting point with a select for this?

 

[ProbablyDown]

To find all tapes used by a node - issue the following SQL:

select volume_name,last_write_date from volumes where volume_name in (select volume_name from volumeusage where node_name='<your_node')

Then just look for the dates you need.

 

[MoreFeo]

Not sure, but I think a select on CONTENTS table could do the trick, something like:

select volume_name from contents where file_name='PATH\AND\NAME_OF_FILE' and node_name='YOUR_NODE'

Don't have a TSM server right now to check this out, but I think it should work.

 

[mbourne2006]

Hi

You might like this, or not ...

select * from syscat.columns where tabname='VOLUMEUSAGE'

or

select * from syscat.columns where tabname='CONTENTS'

Take a look at the indexes - this will give you a good idea of how to write your select statements efficiently

Have Fun !
Matthew Bourne
"Find a job you love and never do a day's work in your life.

 

[oxyg3n]

http://www.lascon.co.uk/d005104.htm#sqlfvol

the SQL hint at LasCon could be "polished", of course but anyway, you can find a lot of other useful stuff there... enjoy!