It's just a flat file, right?!?  Maybe try (a) query to find the volumes
assigned, (b) then shutdown dsmserv, (c) delete the associated lines, (d)
fire up dsmserv, and (finally?) run auditdb to clean up the current db...
something to try, if you've already exhausted admin-client parameter
combinations.  Of course, backup things before embarking on this path.

Alternatively, try setting future time, "del volhist" then reset to present
date, backup db (as normal)... also, be backed up for this scenario, in case
it doesn't work as desired.



Don France

Technical Architect, P.A.C.E.
San Jose, CA
mailto:dfrance AT pacbell DOT net
PACE - http://www.pacepros.com
Bus-Ph:   (408) 257-3037




> -----Original Message-----
> From: Kelly J. Lipp [mailto:lipp AT STORSOL DOT COM]
> Sent: Tuesday, December 21, 1999 12:53 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Trouble Deleting DB Volhist Records
>
>
> Hey gang,
>
> TSM V3.7.1 for NT
>
> Unbeknownst to me, the system clock on my TSM server was set
> in future time.
> I guess it thought a Y2K test was in order.  The date was set
> to 1/20/2000
> for a few days.  DB Backups were run during this time.  I
> then discovered
> the problem and set the date correctly.  So I've got dbbackup
> entries in the
> future.  I was able to delete a couple of them by doing
> todate=today+30, but
> I couldn't get them all.  So now I've got dbbackups from a
> month from now
> and some from a few days ago until I ran out of tapes in the
> library.  So
> simple, right?  Delete the volhist records using delete
> volhist type=dbb
> todate=today.  That isn't working.  I'm getting a "0 volume
> history records
> deleted."
>
> Any ideas are appreciated.  I've considered going into future
> time again and
> doing another db backup and then trying to delete all of the
> previous ones,
> but that still leaves me in a bit of a bind as I'd really
> like to be in
> present time!
>
> Thanks,
> Kelly J. Lipp
> Storage Solutions Specialists, Inc.
> PO Box 51313
> Colorado Springs CO 80919
> (719)531-5926
> Fax: (719)260-5991
> www.storsol.com
> lipp AT storsol DOT com
>