TSMManager uses the following select to get the list of DBBackup volumes:

select
date_time,volume_name,type,backup_series,volume_seq,devclass,location from
volhistory where backup_operation<>99

and results in:

11:41:59 AM   WIND : select
date_time,volume_name,type,backup_series,volume_seq,devclass,location from
volhistory where backup_operation<>99

    DATE_TIME: 2009-05-05 11:20:51.000000
  VOLUME_NAME: 085433
         TYPE: BACKUPFULL
BACKUP_SERIES: 21
   VOLUME_SEQ: 1
     DEVCLASS: 3592-E05
     LOCATION:

    DATE_TIME: 2009-05-06 11:00:17.000000
  VOLUME_NAME: 085244
         TYPE: BACKUPFULL
BACKUP_SERIES: 22
   VOLUME_SEQ: 1
     DEVCLASS: 3592-E05
     LOCATION:



From:
Joerg Pohlmann <jpohlman AT CA.IBM DOT COM>
To:
ADSM-L AT VM.MARIST DOT EDU
Date:
05/05/2009 06:24 PM
Subject:
Re: [ADSM-L] how to view the content of a database (db)
Sent by:
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



I assume you meant a database backup volume. For TSM 6.1, I do not know of
any way to display the contents of a database backup volume as has existed
in pre-TSM 6.1 (see the TSM 5.5 Admin Ref book under "Server Utilities").
Hence the comments in the documentation that the volume history is crucial
for any database restore. A reminder - a prepare command saves the volume
history in the disaster recovery plan file.

If you issue

dsmserv display dbb devc=sata vol=41127511.dbv

TSM 6.1 gives

ANR4855I Command DISPLAY DBBACKUPVOLUMES is no longer supported and there
is no direct replacement for this capability.

Joerg Pohlmann
250-245-9863