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 <feridch AT YAHOO DOT COM>
Sender: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Date: Fri, 23 Sep 2011 01:40:06
To: <ADSM-L AT VM.MARIST DOT EDU>
Reply-To: Ferid Cholich <feridch AT yahoo DOT 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.
|