Hi Does anyone know how to determine the volume on which a backupset is stored when a nodegroup containing several nodegroupmembers (i.e. a stacked set of backupsets) is used.
For a single node , i.e. generate backupset nodename backupsetprefix ... the old select * from backupsets, volhistory where backupsets.date_time = volhistory.date_time worked very nicely before 5.4.1.0 (we even used to teach this select statement in TSM classes). It still works when you do the generate backupset nodename ... on 5.4.1.0. However, when you do a generate backupset nodegroupname backupsetprefix ... the date_time stamp in the backupsets table reflects the start of the backupset creation, whereas the date_time in the volhistory table reflects the time of the completion of the generate backupset nodegroupname ... process. If your practice is to only have one generate backup nodegroupname ... per day, then a select * from backupsets, volhistory where date(backupsets.date_time) = date(volhistory.date_time) will give you correct output. It still does not give you with absolute certainty the volumes for an individual backupset when you do multiple generate backupset nodegroupname ... on a given day. Any help would be appreciated. Regards, Joerg Pohlmann 250-245-9863
