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 [EMAIL PROTECTED] -- 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.
