ADSM-L

Re: [ADSM-L] Canot delete volhist after load db

2007-06-08 04:34:18
Subject: Re: [ADSM-L] Canot delete volhist after load db
From: Remco Post <r.post AT SARA DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 8 Jun 2007 10:33:21 +0200
Doug Fox wrote:
> Can't you just change your retention of DBBackup sets to 1 and let it
> expire
> itself, then change it back? Or am I not thinking about the same thing? I
> would think this would remove it from volhist as well.
> 

depend on weather or not you use drm, but delete volhist -todate=-5
force=y does do the trick (at least did t=it for me), and should be
better documented.

> On 6/6/07, Richard Sims <rbs AT bu DOT edu> wrote:
>>
>> On Jun 6, 2007, at 10:48 AM, חנה דרזי wrote:
>>
>> > After Unload and load database 5.3.5 on windows.
>> > When I triy to delete dbbackup records from volume history I get:
>> > DELETE VOLHISTORY: 0 sequential volume history entries were
>> > I delete volumes from 4 days befor and I have volumes from 30 May
>> >
>> > How can I fix it ?
>>
>> This was pursued recently with another customer.  See the thread at
>> http://www.mail-archive.com/adsm-l AT vm.marist DOT edu/msg71919.html
>>
>> Database reload resets the DBBackup Series number, resulting in this
>> situation.  Using the undocumented Force parameter of DELete
>> VOLHistory is a way out of it.
>>
>> This is another reason to not do database Unload-Reload without a
>> VERY good reason.  (Hope of improving DB performance does not
>> constitute such a reason, in my experience.)
>>
>>     Richard Sims
>>


-- 
Met vriendelijke groeten,

Remco Post

SARA - Reken- en Netwerkdiensten                      http://www.sara.nl
High Performance Computing  Tel. +31 20 592 3000    Fax. +31 20 668 3167
PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16  B3F6 048A 02BF DC93 94EC

"I really didn't foresee the Internet. But then, neither did the
computer industry. Not that that tells us very much of course - the
computer industry didn't even foresee that the century was going to
end." -- Douglas Adams