Guys,

     don't rely on last_use when scanning for db backup volumes. A volumes
     last_use status can get reset, for example when a db volume once
     checked out, is checked back in again.

     Try something like this:

     select volume_name from volhistory where -
     (upper(type)='BACKUPFULL' or upper(type)='BACKUPINCR')


     regards Walter Ridderhof

______________________________ Reply Separator _________________________________
Subject: Re: detecting database backup volumes
Author:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> at INET-1
Date:    2/15/00 3:44 PM


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
>