you caught me having fun with the select statement ... here's a working
example.  You can use or not use the comma delimited parms as wanted.
and the - at the end of the first line is a continuation character ...

select volume_name,status,last_use from libvolumes where -
last_use='DbBackup'


On Tue, 15 Feb 2000, Joel C McCarty wrote:

> Is there a simpler way from the cmd line client for Aix to determine a
> volume was used for a db backup than searching for the tape name from the
> results of
>
> q volh type=dbb
>
> in this case I already know the tape name and want to see if it was used
> for a db backup.
>
> Thanks,
>
> Joel McCarty
>