Michael,

some time ago, I asked the same question. The conclusion was, that there
is no way to get that information. The reason is a weakness in the SQL
table layout: the CONTENTS table does not contain the OBJECT-ID field
which would link it to the BACKUPS (or ARCHIVES) table, which in turn
contains the requested information.

Michael Garnebode writes:
> Hi ADSM'ers,
>
> i have a damaged volume without copy.
> My problem is what kind of backup version (inactiv/active/backupdate) of a
file is damaged.
> I can do a q content or select * from content to see the damaged files.
> I can do a dsmc q ba -ina or a select * from backups to see how much
versions are exist from the damaged file
> but i can't see the backup date of the damaged file on the damaged tape.
>
> Any ideas?
>
> Michael Garnebode
>
>
>
>
>
>
>
>
> html;charset=iso-8859-1 http-equiv=Content-Type>
>
> Hi ADSM'ers,
>
>
>
> i have a damaged volume without copy.
>
> My problem is what kind of backup version (inactiv/active/backupdate) of a
> file is damaged.
>
> I can do a q content or select * from content to see the damaged files.
>
> I can do a dsmc q ba -ina or a select * from backups to see how much
versions
> are exist from the damaged file
>
> but i can't see the backup date of the damaged file on the damaged tape.
>
>
>
> Any ideas?
>
>
>
> Michael Garnebode
>
>
>
>
>
>
>
>
>
>
>
>
--
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Zentrum fuer Informationsverarbeitung - ehemals Universitaetsrechenzentrum
Roentgenstrasse 9-13, D-48149 Muenster, Germany      Tel: +49(251)83-31583
E-Mail: mersch AT uni-muenster DOT de                       Fax: 
+49(251)83-31653