list all tapes with 1 particular node data

[waikuan_my]

Is there anyway or command that can use to list out all the tapes being used to backup a particular node ? Im using the non-collocation method, therefore those data are spread in different tapes. I wish to know all the labelname (tapes) for restoring purpose.

 

[JohanW]

q nodedata <node>

 

[waikuan_my]

I'm using TSM5.2, the command is not supported.
ANR2000E Unknown command - QUERY NOTEDATA

 

[BBB]

select volume_name,sum(file_size)/1024/1024 as VERY_APPROX_MB,count(file_size) as NumFiles
from contents where node_name='NODENAMEHEREINCAPITALS'

May take a long time to run.

Edit: Ignore this post...

 

[JohanW]

Yeah, you could probably upgrade to 5.4 (which, unlike 5.2, is supported! ) in the time that query takes to run.

 

[BBB]

Hahahaha

Duuuhhhhhhh. Sorry about that. Best query to use is actually:

select distinct volume_name from volumeusage where node_name='NODENAMEINALLCAPS'

Essentially I thinks its all "q nodedata" actually does anyway! And it will won't take all year.

 

[inestler]

show volumeusage nodename

 

[max]

hi,

what about this ?

Select distinct node_name, volume_name, stgpool_name from volumeusage where node_name='xxxxx'

cheers
max