Thanks Rejean, and thanks for not saying RTFM (blush). Best regards,
Joerg Rejean Larivee/Quebec/[EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" <[email protected]> 2007-09-11 12:08 Please respond to "ADSM: Dist Stor Manager" <[email protected]> To [email protected] cc Subject Re: Fw: TSM 5410 - how can I find the volume(s) on which stacked backsets are stored? Hello Joerg, with TSM 5.4, the QUERY BACKUPSET command now has the detailed format output available (F=D). If you use the detailed format output, it should display the volume. For example : tsm: TSM02>q backupset mygroup f=d Node Name: TESTNODE1 Backup Set Name: TEST.102407 Data Type: File Date/Time: 09/11/2007 14:51:11 Retention Period: 365 Device Class Name: LTOCLASS Description: No Description Has Table of Contents (TOC)?: No Filespace names: \\ABC123\c$ Volume names: TSM010L2 Node Name: TESTNODE2 Backup Set Name: TEST.102407 Data Type: File Date/Time: 09/11/2007 14:51:11 Retention Period: 365 Device Class Name: LTOCLASS Description: No Description Has Table of Contents (TOC)?: No Filespace names: \\ABC123\c$ Volume names: TSM010L2 This was a backupset generated for the MYGROUP group which contains the TESTNODE1 and TETSNODE2 nodes. As for the discrepancy in date/time reported by the backupsets table and the volhistory table, this was recently reported and APAR IC53179 is currently opened on the subject. In the meantime, you can use QUERY BACKUPSET <group> F=D to get the volume name. Have a great day! Rejean Larivee IBM Tivoli Storage Manager support IBM Global Technology Services ********************************************************************************************************** Visit our new IBM Tivoli Storage Manager support page: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html Expand IBM Tivoli product knowledge through our Support Technical Exchange. http://www-306.ibm.com/software/sysmgmt/products/support/supp_tech_exch.html ********************************************************************************************************** "ADSM: Dist Stor Manager" <[email protected]> wrote on 09/11/2007 01:18:09 PM: > In case anyone is interested - a small refinement to the select statement > to omit clutter: > > select * from backupsets, volhistory where date(backupsets.date_time) = > date(volhistory.date_time) and volhistory.type in ('BACKUPSET','BACKUPSET > FULL') > > Comments from development on how to really find the volume for a backupset > would be appreciated. > > Regards, > > Joerg > > > ----- Forwarded by Joerg Pohlmann/CanWest/IBM on 2007-09-11 09:14 ----- > > Joerg Pohlmann/CanWest/IBM > 2007-09-09 13:55 > > To > [email protected] > cc > > Subject > TSM 5410 - how can I find the volume(s) on which stacked backsets are > stored? > > > > > > 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
