OK,  based on feedback I have gone ahead and run "del volhist t=dbb
tod=-10".  This has worked fine and the q volhist gives the correct result.

However we also use DRM, and the DBB volumes are automatically managed
by DRM so their movements to offsite storage, and back again when they
are no longer required, are managed properly.  The additional tapes
have now simply been removed from the DRM database without going
through vaultretrieve and courierretrieve states.  Therefore for our
operators they will have no idea that the tapes need to be retrieved
from offsite storage.

I will just need to reconcile between the DRM list and what we actually
have stored.  But I wouldn't like to do this everyday!

To me this sounds like a bug.  The DRM should not delete the volume
entry until it has been retreived from the offsite location.

For the moment I won't be running this schedule on a daily basis!

Any comments?

Regards,
Simon
----------
| From: ADSM-L AT VM.MARIST DOT EDU; Trevor.Foley AT BANKERSTRUST.COM DOT AU
| From: ADSM-L AT VM.MARIST DOT EDU; Trevor.Foley AT BANKERSTRUST.COM DOT AU
| To: ADSM-L AT VM.MARIST DOT EDU
| Subject: Re: DB Backup Volumes
| Date: Thursday, 21 May, 1998 8:09AM
|
| Hi Simon,
|
| No, there is no parameter to set. You need to set up the 'delete
| volhist' schedule.
|
| There is one thing that I have noticed since upgrading to V3. When an
| EXPIRE INVENTORY job finishes, the summary information written to the
| activity log says how many backup and archive objects were deleted, but
| it also says how many DB backup volumes were deleted. In our case this
| is always 0. Anyone know what this is about? Maybe there is a setting
| somewhere so that EXPIRE INVENTORY takes care of old DB backup volumes.
|
|
| Trevor
| ------------------------------------------------------------------------
| ------------------------------------------------
| Trevor Foley
| Bankers Trust Australia Limited
| Phone: 61-2-9259 3944    Fax: 61-2-9259 2659
|
|
|         -----Original Message-----
|         From:   Simon Watson
| [SMTP:Simon.S.Watson AT OPENMAIL.FIC32.BSPSER.SIMIS DOT COM]
|         Sent:   Wednesday, May 20, 1998 6:55 PM
|         To:     ADSM-L AT VM.MARIST DOT EDU
|         Subject:        Re: DB Backup Volumes
|
|         This sounds strange to me!  My DB backups seem to be kept for 1
| month
|         and then expire, so I am dedicating 30 3590 tapes to holding DB
|         backups.  As mentioned this is a bit excessive.  Isn't there a
|         parameter somewhere to specify how long to keep them for rather
| than
|         running a regular schedule with "del volhist t=dbb tod=-###"?
|
|         The only thing I can think of is that it uses the Standard
| Policy
|         Domain, which in my case has the backup retention set to 30
| days.  I
|         suppose I could just reduce this.
|
|         Cheers,
|         Simon
|
|         ----------
|         | From: ADSM-L AT VM.MARIST DOT EDU; Cris.Robinson AT LIBERTYMUTUAL 
DOT COM
|         | To: ADSM-L AT VM.MARIST DOT EDU
|         | Subject: Re: DB Backup Volumes
|         | Date: Wednesday, 20 May, 1998 12:02AM
|         |
|         | I have to jump in for a sec. I also use the "del volhist t=dbb
| tod=-###"
|         | command but I find that
|         | ADSM finds that the media is innaccessable the next time the
| particular
|         | tape comes up in the
|         | rotation for database backups. Any thoughts on that subject?
|         |
|         | Thanks -
|         | CR
|         |
|         | ________________________
|         | Cris Robinson
|         | Senior Technical Analyst
|         | Desktop Services Technical Support
|         | Liberty Mutual Insurance
|         | 603.431.8400.54837
|         | cris.robinson AT libertymutual DOT com
|         |
|         | > -----Original Message-----
|         | > From: Dwight Cook [SMTP:decook AT AMOCO DOT COM]
|         | > Sent: Tuesday, May 19, 1998 11:14 AM
|         | > To:   ADSM-L AT VM.MARIST DOT EDU
|         | > Subject:      Re: DB Backup Volumes
|         | >
|         | >      Also a "query volhist t=dbb"  (that is
| type=databasebackup) will
|         | > show
|         | >      you what is there.... to get rid of them and let the
| volumes roll
|         | > back
|         | >      into scratch status you simply do a "del volhist t=dbb
| tod=-###"
|         | > where
|         | >      ### is a number of days to go back in time from the
| current date.
|         | > I
|         | >      use "" so I delete db backups
| older than
|         | > one
|         | >      week. NOW I WOULD NEVER THINK OF trying to recover from
| a week
|         | > old
|         | >      dbbackup 'cause of the time involved to audit everyting
| but this
|         | > gives
|         | >      me the ability to say I'm covering things to my best
| ability.
|         | >      later
|         | >           Dwight
|         | >
|         | >
|         | >
|         | > ______________________________ Reply Separator
|         | > _________________________________
|         | > Subject: Re: DB Backup Volumes
|         | > Author:  HWhitehead (HWhitehead AT CAISO DOT COM) at unix,mime
|         | > Date:    5/18/98 6:47 PM
|         | >
|         | >
|         | > From the administrative command line, use q libvolume
| (format=detailed
|         | > if you want much detail).  The far right hand column will
| give you
|         | > your
|         | > info.
|         | >
|         | > Hilary Whitehead
|         | > California Power Exchange
|         | >
|         | > > -----Original Message-----
|         | > > From: Greg Garrison [SMTP:Greg.A.Garrison AT BANKAMERICA DOT 
COM]
|         | > > Sent: Friday, May 15, 1998 4:21 PM
|         | > > To:   ADSM-L AT VM.MARIST DOT EDU
|         | > > Subject:      DB Backup Volumes
|         | > >
|         | > > Hi all!
|         | > >
|         | > > You know... this is one of those questions I feel
| embarrassed to
|         | > ask,
|         | > > but I
|         | > > can't remember where I can go to find out which of my
| tapes contain
|         | > DB
|         | > > backups.  Sure could use some help.
|         | > >
|         | > > Greg Garrison
|         | > > Bank of America
|         |
|