All,
I'm using TSM 5.1.6.1 on AIX 5. I backup NT and Solaris, AIX, Linux clients.
All are running v5.1.5.x client.
TSM doesn't keep track of volumes used to create a backup set. I've found that
I can get around this by querying the VOLHISTORY and BACKUPSETS tables and join
them using the DATE_TIME field. Assuming 2 backup sets weren't created at
exactly the same time (to the second), this seems to be a way of keeping track
of which volumes are used for backup sets.
Here's the query I run
select backupset_name, volume_name, volume_seq from backupsets, volhistory
where type = 'BACKUPSET' and backupsets.date_time = volhistory.date_time order
by backupset_name, volume_seq
Am I correct? Opinions appreciated
Thanks
Mark
--
Mark Ferraretto
Unix Systems Administrator
Deutsche Bank Hong Kong
w: +852 2203 6362 m: +852 9558 8032 f: +852 2203 6971
mark.ferraretto AT db DOT com
--
This e-mail may contain confidential and/or privileged information. If you are
not the intended recipient (or have received this e-mail in error) please
notify the sender immediately and destroy this e-mail. Any unauthorized
copying, disclosure or distribution of the material in this e-mail is strictly
forbidden.
|