Rushforth, Tim wrote:
> That sounds similar to a problem we had years ago (APAR IC30429) - have
> you tried the "FORCE=YES" option.
>
I is exactly what I see on one of our servers:
tsm: BASKET>q volhist t=dbs
Date/Time Volume Type Backup Backup
Volume Device Class Volume Name Volume
Location Command
Series Operation
Seq
-------------------- -------------- ------ ---------
------ ------------ ------------------------------
------------------------------ ------------------------------
05/23/2006 08:18:09 DBSNAPSHOT 449 0
1 9940B 200894
05/24/2006 08:18:05 DBSNAPSHOT 450 0
1 9940B 204480
05/25/2006 08:18:26 DBSNAPSHOT 451 0
1 9940B 203142
04/01/2007 08:17:20 DBSNAPSHOT 302 0
1 9940B 204626
04/03/2007 08:17:33 DBSNAPSHOT 303 0
1 9940B 201304
04/04/2007 08:20:33 DBSNAPSHOT 304 0
1 9940B 200869
04/05/2007 08:17:39 DBSNAPSHOT 305 0
1 9940B 201297
using force=yes solved my problem for these 3 dbs volumes, thanks!
(I am using server version 5.3.4.1, which is a tad more recent than the
apar fix!)
> Tim Rushforth
> City of Winnipeg
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> TSM User
> Sent: Friday, March 30, 2007 12:44 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] Help DELETE VOLHISTORY
>
> No, he is not most recent. She is but the old one.
> See the Volhistory...
>
> select * from volhistORY where type = 'BACKUPFULL'
>
>
>
> DATE_TIME: 2007-02-23 09:40:03.000000
>
> UNIQUE: 0
>
> TYPE: BACKUPFULL
>
> BACKUP_SERIES: 117
>
> BACKUP_OPERATION: 0
>
> VOLUME_SEQ: 1
>
> DEVCLASS: LTOCLASS1
>
> VOLUME_NAME: DB.BACKUP.4
>
> LOCATION:
>
> COMMAND:
>
>
>
> DATE_TIME: 2007-03-02 09:03:38.000000
>
> UNIQUE: 0
>
> TYPE: BACKUPFULL
>
> BACKUP_SERIES: 118
>
> BACKUP_OPERATION: 0
>
> VOLUME_SEQ: 1
>
> DEVCLASS: LTOCLASS1
>
> VOLUME_NAME: DB.BACKUP.5
>
> LOCATION:
>
> COMMAND:
>
>
>
> DATE_TIME: 2007-03-22 15:45:12.000000
>
> UNIQUE: 0
>
> TYPE: BACKUPFULL
>
> BACKUP_SERIES: 2
>
> BACKUP_OPERATION: 0
>
> VOLUME_SEQ: 1
>
> DEVCLASS: LTOCLASS1
>
> VOLUME_NAME: DB.BACKUP.2
>
> LOCATION:
>
> COMMAND:
>
>
>
> DATE_TIME: 2007-03-23 08:46:31.000000
>
> UNIQUE: 0
>
> TYPE: BACKUPFULL
>
> BACKUP_SERIES: 3
>
> BACKUP_OPERATION: 0
>
> VOLUME_SEQ: 1
>
> DEVCLASS: LTOCLASS1
>
> VOLUME_NAME: DB.BACKUP.3
>
> LOCATION:
>
>
> On 3/30/07, Lee, Gary D. <GLEE AT bsu DOT edu> wrote:
>> I'm guessing that this is your most recent db backup.
>> If that is the case, you can't delete it. If you really must, then do
>> another db backup then you will be able to delete.
>>
>>
>> Gary Lee
>> Senior System Programmer
>> Ball State University
>> phone: 765-285-1310
>>
>>
>> -----Original Message-----
>> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
>> TSM User
>> Sent: Friday, March 30, 2007 11:46 AM
>> To: ADSM-L AT VM.MARIST DOT EDU
>> Subject: Help DELETE VOLHISTORY
>>
>> Somebody can help me with this?
>>
>> I need to eliminate volume DB.BACKUP.4.
>>
>> delete volhistory todate=today-30 type=DBBackup
>>
>> It does not eliminate it.
>>
>> I suppose that it is by "BACKUP_SERIES".
>>
>>
>>
>> select * from volhistORY where type = 'BACKUPFULL'
>>
>>
>>
>> DATE_TIME: 2007-02-23 09:40:03.000000
>>
>> UNIQUE: 0
>>
>> TYPE: BACKUPFULL
>>
>> BACKUP_SERIES: 117
>>
>> BACKUP_OPERATION: 0
>>
>> VOLUME_SEQ: 1
>>
>> DEVCLASS: LTOCLASS1
>>
>> VOLUME_NAME: DB.BACKUP.4
>>
>> LOCATION:
>>
>> COMMAND:
>>
>>
>>
>> DATE_TIME: 2007-03-02 09:03:38.000000
>>
>> UNIQUE: 0
>>
>> TYPE: BACKUPFULL
>>
>> BACKUP_SERIES: 118
>>
>> BACKUP_OPERATION: 0
>>
>> VOLUME_SEQ: 1
>>
>> DEVCLASS: LTOCLASS1
>>
>> VOLUME_NAME: DB.BACKUP.5
>>
>> LOCATION:
>>
>> COMMAND:
>>
>>
>>
>> DATE_TIME: 2007-03-22 15:45:12.000000
>>
>> UNIQUE: 0
>>
>> TYPE: BACKUPFULL
>>
>> BACKUP_SERIES: 2
>>
>> BACKUP_OPERATION: 0
>>
>> VOLUME_SEQ: 1
>>
>> DEVCLASS: LTOCLASS1
>>
>> VOLUME_NAME: DB.BACKUP.2
>>
>> LOCATION:
>>
>> COMMAND:
>>
>>
>>
>> DATE_TIME: 2007-03-23 08:46:31.000000
>>
>> UNIQUE: 0
>>
>> TYPE: BACKUPFULL
>>
>> BACKUP_SERIES: 3
>>
>> BACKUP_OPERATION: 0
>>
>> VOLUME_SEQ: 1
>>
>> DEVCLASS: LTOCLASS1
>>
>> VOLUME_NAME: DB.BACKUP.3
>>
>> LOCATION:
>>
--
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
|