TSM select to determine which tape contain all files of a specified directory

[tivolimistery]

Hi all,

I use TSM v.5.5.4 for BA/HSM purposes.
I need to know on which tape are stored all files of directory "/example" of filespace "/tsmfilespace".

In other words I need to locate which tape contains all files stored in "/tsmfilespace/example" directory.

I used this query:

select volume_name,node_name,filespace_name,file_name from contents where node_name='NODE' and filespace_name='/tsmfilespace' and file_name='/tsmfilespace'

but it doesn't work!
Do you know the right way to do it?

Thank you so much.
Mauro Tridici

 

[chad_small]

you should probably use the following statement:

select volume_name, node_name, filespace_name, file_name from contents where node_name='NODE' and filespace_name like '%tsmfilespace%' and file_name like '%example%'

This might not return since it's so big, so you might consider running it against a specific tape. Use Q NODEDATA to list the tapes that the node has data on.

 

[tivolimistery]

Thank you CHAD!
It works!

Have a great day!
Mauro Tridici