ADSM-L

Re: [ADSM-L] Help DELETE VOLHISTORY

2007-03-30 13:21:08
Subject: Re: [ADSM-L] Help DELETE VOLHISTORY
From: "Lee, Gary D." <GLEE AT BSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 30 Mar 2007 13:20:43 -0400
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: