Hi Ferid, With the 6.x client, there is a new option called querysummary for query backup and query archive commands. Using this option adds information about the data query (volume of data, number of files...) and the number of volumes required to satisfy the equivalent restore or retrieve.
There is also an undocumented similar option called querydetail that give the ID of the volumes required, in an hexa form. You then need to convert it to decimal (or vice-versa) and then look in the TSM database called ss_volumes_id (or something similar) to convert volume IDs to volume names. I don't have the full and precise method with me but that's'the idea. Regard, Erwann -- Best regards / Cordialement / مع تحياتي Erwann SIMON -----Original Message----- From: Ferid Cholich <feri...@yahoo.com> Sender: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> Date: Fri, 23 Sep 2011 01:40:06 To: <ADSM-L@VM.MARIST.EDU> Reply-To: Ferid Cholich <feri...@yahoo.com> Subject: [ADSM-L] List of tapes needed for partial restore. Hi, This problem is old as ADSM, but become more important with clients become bigger and bigger. I need to restore one folder for windows server and need list of tapes to be mounted. In past, when I needed to restore entire node, I used to use command: select distinct * from volumeusage where node_name=’ my NODE ‘ so I get the list of 200-300 tapes, combined in script with the list of mounted tapes, to get a new list of 50-100 tapes needed to be mounted. The other way is to start NQR (non query restore) which build list of needed tapes, and then to cancel restore and see the difference, of what need to be mounted. IBM-TSM support advice is to send a DCR (Design Change Request), and request this funcionality of TSM in the future. Now, I am wandering, is anybody ever faced the same issue and/or found some other trick or workaround for this and how. Thanks, Ferid.
