>Replace $1 with the volume name and this LONG RUNNING query will tell you >what nodes are on a tape: > >select distinct node_name from volumeusage where volume_name='$1'
It may be more expeditious to do 'Query CONtent VolName > os-filename' and process the report file externally, given the speed of the artificial SQL layer over the TSM database and that the Query commands are optimized for the true database. This also provides the opportunity to harvest more information from the contents spew (number of files, type, filespace, etc.) without having to perform yet another Select. Richard Sims, BU
