Getting it to match to a session is impossible. The closest thing I can think of is the output from a "q nodedata NODENAME" command. That will tell you what tapes that host has data on that may or may-not need to be mounted depending on the extent of the restore.
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Thursday, October 12, 2006 9:12 AM To: [email protected] Subject: Re: Finding Volume Names On Oct 12, 2006, at 10:41 AM, Gopinathan, Srinath wrote: > Can anybody let me know on 'How to find the list of Volumes associated > with a backup, from the schedule name (or) nodename?' There is no real way to determine what volumes were associated with a specific backup. The Volumeusage table is no good because it contains all primary and copy storage pool tapes associated with the node, regardless of date. You could bracket a time period in the Activity Log and try to discern tape usage by virtue of mounts, but that's messy, and doesn't account for volumes which happened to already be mounted (residual tape - or disk, for that matter). You could try doing a Select from the Backups table, again trying to isolate by time period, but that's expensive to run and doesn't necessarily correlate to a session. Consider also that, at any time thereafter, the objects may move to a different volume. In any case, the nature of an Enterprise level product like TSM is that you should not need to know this information, as is the case in many virtualization technologies today: the managing subsystem takes care of data provisioning, and "you don't need to know". Richard Sims
