ADSM-L

Re: DB2 Backup expire

1999-11-13 12:38:12
Subject: Re: DB2 Backup expire
From: Gyula Bereczky <bx AT MAIL.DATATRANS DOT HU>
Date: Sat, 13 Nov 1999 18:38:12 +0100
On Fri, Nov 12, 1999 at 02:56:22PM -0500, Lawrence Clark wrote:
> The data would still be on the cartridge and an extry in the database until 
> the tape was reclaimed. At that point valid data would be placed on a new 
> tape and the old tape returned to the scratch pool.
>
No, this is not correct. After expiration no database entry exists for an
expired file. The file is on the tape, but query content would not show it.

> Have you tried doing an explicit move data nnnnnn (where nnnnnn is the 
> volume) , then doing a q content to see if the expired data still shows?
>
> Larry Clark
> NYS Thruway Authority
>
> >>> Gyula Bereczky <bx AT MAIL.DATATRANS DOT HU> 11/12/99 03:56PM >>>
> On Sun, Dec 12, 1999 at 05:09:22PM -0200, Fabiano Costa wrote:
> > Hi all !
> >
> >             I have a problem with ADSM 3.1.2.40 with DB2, ADSM doesn't
> > expire any versions !!! I try to expire through smitty it expires from
> > DB2 but not from ADSM database. I can see the data in the volumes with
> > "q content" command !!!
> >
> > Help me!
> > Tks in advance,
> > Fabiano.
> Fabiano,
> there is a special utility in the $DB2INSTANCE/sqllib/adsm directory called
> db2adutil. With this tool you can delete/mark inactive your db backups in
> ADSM/TSM. If your management class/backup copy group for db/2 backups has
> "Versions Data Deleted" set to 0, the next expiration your deleted/inactivated
> backup should disappear from *SM.
> --
<Prev in Thread] Current Thread [Next in Thread>