ADSM-L

Problem deleting database backup volhistory records

2000-09-18 18:45:22
Subject: Problem deleting database backup volhistory records
From: Trevor Foley <Trevor.Foley AT BTFINANCIALGROUP DOT COM>
Date: Tue, 19 Sep 2000 09:32:25 +1100
G'day,

I've got a small problem with deleting database backup records from the 
volhistory file. I have records in there going back about 5 weeks but we 
normally only keep a few days worth. If I do 'delete volh type=dbb 
todate=today-5' no records are removed even though 8 records more than that age 
exist as shown by 'q volh type=dbb'.

The cause I think is the backup series number. The numbers for the 8 records 
that I cannot remove are 1377 through 1380 (there are a mix of full and 
incremental backups). Whereas the more recent backup series are 1248 through 
1250. How I managed to get some older backup series with higher numbers I have 
no idea.

Any ideas as to how I can fix this? One option is to wait the 130 or so days 
until the current backup series number reach the older numbers. But my concern 
is that if I wait until then I might find myself in a position where I am 
unable to perform a database backup due to conflicting backup series numbers.


thanks,

Trevor

------------------------------------------------------------------------------
This message and any attachment is confidential and may be privileged or 
otherwise protected from disclosure.  If you have received it by mistake please 
let us know by reply and then delete it from your system; you should not copy 
the message or disclose its contents to anyone.
This message and any attachment is confidential and may be privileged or 
otherwise protected from disclosure.  If you have received it by mistake please 
let us know by reply and then delete it from your system; you should not copy 
the message or disclose its contents to anyone.
<Prev in Thread] Current Thread [Next in Thread>
  • Problem deleting database backup volhistory records, Trevor Foley <=