"ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> wrote on 08/06/2003 05:28:21 AM:
> 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 > This has always worked well for us. ______________________________ John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-221-6938 http://www.compures.com
