Quoting "Jolley, Bill" <bill.jolley AT EDS DOT COM>:

> I have a strange request. I have an Oracle DB that was taken on April
> 20,
> 2001.  I am being asked to determine the volumes used for db backup and
> the
> archive logs and preserve these volumes for 6 plus months. My activity
> log
> is kept for seven days only; the db backup and the archive logs are
> offsite
> for 14 days. Is there a more effecient way of determining the volumes
> used
> besides the "show volumeusage" command followed by the "query content"
> command.

I don't know of an alternative to the commands you mention, but you
may be able to make the "query content" less painful than you expect.
On our 3.7 server, the "query content" command has operands for
selecting the files listed by node and file system.

You will need to save a copy of an ADSM or TSM database backup taken
while the Oracle backups of interest were part of the server's inventory
of backup files.