Re: [ADSM-L] Help DELETE VOLHISTORY
2007-03-30 13:44:08
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:
|
|
|