Which tapes contain what data?

Silent700

ADSM.ORG Member
Joined
Feb 2, 2007
Messages
6
Reaction score
0
Points
0
Hopefully this is another easy one. I searched around the forums for the answer before posting, but it's a difficult topic to search on.

I have just about conquered DR and DR testing. We staged a "disaster" and restored our server to new hardware, restored the catalog from tape, and brought some data back from the data pools. To accomplish this, we brought back the entire offsite copy pool (~12 LTO3 tapes.)

Say I can't/don't want to bring back the entire tape set. I would like to restore the data from server x - how can I determine what tape(s) I need to restore this data? Is there a TSM command that will show this directly, or does an SQL query have to be constructed? I'm aware of 'q occ,' 'q fil' and 'q con,' and can see how I could get the answer out of these with a good deal of crunching in Excel, but I'm hoping for a more direct approach.

TiA -

-j
 
QUERY NODEDATA <nodename>

or

SELECT DISTINCT VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='node_name'
 
Back
Top