Re: [ADSM-L] Help DELETE VOLHISTORY
2007-03-30 13:57:24
That sounds similar to a problem we had years ago (APAR IC30429) - have
you tried the "FORCE=YES" option.
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:
>
|
|
|