Hi,  Can I suggest a slightly different approach?

It's always been my understanding that when you use DRM and set the
value DRMBACKUPEXPIREDAYS to whatever, you should then not do DELETE
VOLHIST TYPE=DBB at all.  When the MOVE DRM is actioned to move the
tape form COURIERRETRIVE to ONSITERETRIEVE (having got the tape back
and checked it in) then the tape will be removed then from the volume
history automatically.

We make use of MOVE DRM wherest=VAULTRETRIEVE to get tapes back from
offsite, generate (using the cmd and cmdfile options) emails and
checkin commands to help the flow.

This is what we have done for years and it has worked very well for us.

Regards, Sheelagh
------------------------------------------------------------------------------
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Sheelagh Treweek                         Email: sheelagh.treweek AT oucs.ox.ac 
DOT uk
Oxford University Computing Services     Tel:   +44 (0)1865 273205
13 Banbury Road, Oxford, OX2 6NN, UK     Fax:   +44 (0)1865 273275
------------------------------------------------------------------------------
> From owner-adsm-l AT vm.marist DOT edu  Thu Apr 29 17:41:53 1999
> From owner-adsm-l AT vm.marist DOT edu  Thu Apr 29 17:41:53 1999
> X-Lotus-FromDomain: VGNET
> Mime-Version: 1.0
> Content-Disposition: inline
> Date: Thu, 29 Apr 1999 11:24:33 -0400
> From: Scott Fluegge <sfluegge AT VENATORGROUP DOT COM>
> Subject: Re: Disaster-Recovery, Tapes Vanishing!
> To: ADSM-L AT VM.MARIST DOT EDU
>
> Cindy,
>
> What is your "DB Backup Series Expiration Days" set to?  (you can find this by
> using the command: "q drmst".  If that is set to 5 or more days, the tape will
> vanish.  That is because you are telling the drmedia manager to hold it longer
> than ADSM is.  It will never be put in the vault retrieve state.
>
> What I do is run delete volhist type=dbbackup todatae=today-12 and set my  "DB
> Backup Series Expiration Days" to 7 days.  This puts the tapes in the vault
> retrieve state for 5 days which gives me some breathing room.  This said, I am
> still having tapes vanish.  Some are DB Backups, some are not.
>
> Scott
>
>
>
>
>
>
>
> "Bowers, Cindy Ann (CRD)" <bowers AT CRD.GE DOT COM> on 04/29/99 07:02:52 AM
>
> Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> To:   ADSM-L AT VM.MARIST DOT EDU
> cc:    (bcc: Scott Fluegge/COR/MLW/US/venatorgroup)
> Subject:  Re: Disaster-Recovery, Tapes Vanishing!
>
>
>
>
> To answer both Trevor and Edi,
>
> My server is on AIX at version 3.1.15 and we are using DRM. DRM successfully
> sends the DB Backup
> tapes offsite, but never asks for them back.  I am confirming this by querying
> the volhist daily for
> dbbackup.  The tape that is 6 days old (the retention is set at 5) disappears
> completely from DRM.
>
> Cindy Ann
> GE Corp Research & Development
>
> -----Original Message-----
> From: Trevor Foley [mailto:Trevor.Foley AT BANKERSTRUST.COM DOT AU]
> Sent: Wednesday, April 28, 1999 8:51 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Disaster-Recovery, Tapes Vanishing!
>
>
> Hi Cindy,
>
> My understanding is that inventory expiration will only delete DB backup
volumes
> if you have DRM
> installed. Without DRM you are left with doing regular DELETE VOLH TYPE=DBB
> TODATE=TODAY-5 (or
> similar) commands.
>
>
> Trevor
>
> -----Original Message-----
> From: Bowers, Cindy Ann (CRD) [mailto:bowers AT CRD.GE DOT COM]
> Sent: Thursday,29 April 1999 5:59
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Disaster-Recovery, Tapes Vanishing!
>
>
> Scott,
>
> The other thing I notice that may be related is that my expiration process
never
> seems to return any
> dbbackup tapes, even though I do a full db backup daily and retain them for 5
> days.  I wonder if it
> is the db backups that are not getting returned from DRM.
>
> 04/28/99 09:28:20     ANR0812I Inventory file expiration process 147
completed:
>                        examined 55438 objects, deleting 55085 backup objects,
0
>                        archive objects, and 0 DB backup volumes. 0 errors were
>                        encountered.
> 04/28/99 09:28:20     ANR0987I Process 147 for EXPIRE INVENTORY running in the
>                        BACKGROUND processed 55085 items with a completion
state
>                        of SUCCESS at 09:28:20.
>
> "0 DB backup volumes" just doesn't seem right.  I would expect one per day.
>
>
> Cindy Ann Bowers
> Systems Analyst
> GE  Corporate Research and Development
> 1 Research Circle
> KW-C122
> Niskayuna, NY 12309
> 518-387-5801, dial comm 8*833-5801 (phone)
> 518-387-6560, dial comm 8*833-6560 (fax)
> bowers AT crd.ge DOT com
>
> -----Original Message-----
> From: Scott Fluegge [mailto:sfluegge AT VENATORGROUP DOT COM]
> Sent: Wednesday, April 28, 1999 3:36 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Disaster-Recovery, Tapes Vanishing!
>
>
> Thanks to everyone who responded to this problem.  It seems we have an
> undocumented issue here.  I was on the phone with Level 1 (highest) support
last
> night for a different issue and brought this one up while we waited for some
> processing to run.  I was told to document as much as I could about the tapes
> before and after they disappeared as well as how I am discovering them.  I am
> doing so.  I suggest that everyone else that is having the problem do so also.
> I am finding them by running a report of all of the volumes in the vault, and
> vault retrieve states and comparing the total to the number I know are in the
> vault.  When there is a discrepancy I compare the two lists.   I have started
> running the output of a "q drmedia f=d" to a file every day and holding it for
> about 7 days.  That way I have a history of the file before it disappears.  I
am
> going to collect several instances and then open a case with ADSM.  Everybody
> else that sees this happen I urge to do the same thing.  I think we all want
> this problem addressed!
>
> Thanks,
>
> Scott
>