Quoting "Zosimo Noriega (ADNOC IS&T)" <znoriega AT ADNOC DOT COM>:

> Hi All,
> How to determine expiration date of the contents of a volume (media)
> from
> adsm?
> There is a way by using query or select. Is it stored in the db?

I am not sure whether you are thinking of a volume in pending status
or a volume that still has files on it.

The pending status case is easy to deal with. A 'query volume' command
with 'f=d' will report the date and time at which the volume went into
pending status, and a 'query stgpool' command with 'f=d' will report
the reuse delay (the length of time volumes stay in pending status).

The other case is impossible in general because the expiration dates
of files may be changed by the future behavior of the client
systems. An active backup file with an infinite life expectency will
become an inactive backup file with a finite life expectency (barring
a copy group with a retention time of 'nolimit') if and when the TSM
client discovers that the corresponding client file has been deleted
or changed. The finite life expectency of an inactive backup file can
be shortened by the arrival of enough newer versions of the same file
to exceed the version limit in the relevant copy group. The finite
life expectency of an archive file can be shortened by an explicit
request to delete the file.