How about: Select * from volumeusage where node_name='nomenodo' and stgpool_name='nomestgp' and filespace_id= fs# ?
Cordiali saluti Gianluca Mariani Tivoli TSM Global Response Team, Roma Via Sciangai 53, Roma phones : +39(0)659664598 +393351270554 (mobile) [EMAIL PROTECTED] ---------------------------------------------------------------------------------------------------- The Hitch Hiker's Guide to the Galaxy says of the Sirius Cybernetics Corporation product that "it is very easy to be blinded to the essential uselessness of them by the sense of achievement you get from getting them to work at all. In other words â and this is the rock solid principle on which the whole of the Corporation's Galaxy-wide success is founded -their fundamental design flaws are completely hidden by their superficial design flaws"... Geetha Thanu <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 19/04/2004 08.57 Please respond to "ADSM: Dist Stor Manager" To [EMAIL PROTECTED] cc Subject to know volumes of a node Hi all, How to find out the volumes(cartridges) containing the data of a particular node. Is there anyway to do it. Please help.waiting for your replies Thank you Geetha Thanu -