ADSM-L

Re: [ADSM-L] Help DELETE VOLHISTORY

2007-03-30 13:57:24
Subject: Re: [ADSM-L] Help DELETE VOLHISTORY
From: "Rushforth, Tim" <TRushforth AT WINNIPEG DOT CA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 30 Mar 2007 12:56:58 -0500
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:
>