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
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 "del volhist t=dbb tod=-7" 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
        |