ADSM-L

Re: [ADSM-L] Help DELETE VOLHISTORY

2007-04-05 04:46:55
Subject: Re: [ADSM-L] Help DELETE VOLHISTORY
From: Remco Post <r.post AT SARA DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 5 Apr 2007 10:44:29 +0200
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

<Prev in Thread] Current Thread [Next in Thread>
  • Re: [ADSM-L] Help DELETE VOLHISTORY, Remco Post <=