Thanks Rejean,  and thanks for not saying RTFM (blush).

Best regards,

Joerg





Rejean Larivee/Quebec/IBM@IBMCA
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2007-09-11 12:08
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
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" <ADSM-L AT VM.MARIST DOT EDU> 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
> ADSM-L AT VM.MARIST DOT EDU
> 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