DB2 backups as with most database backups are not deleted by directly by *SM.  
us
the DB2 utility db2adutl to delete the backups and log archives.

Gerhard Wolkerstorfer wrote:

> Hi *SMer,
> one of our customers is making a backup of his DB2/2 V6.1 database once a day
> and his files (One Backup = One File in the Database-Filespace!) are stored 
> in a
> filespace where the name of the filespace is the same as the 
> DB2-Database-Name.
> His Commands are:
> 1) to define the managementclass to the backup =>
> "db2 update db configuration for xxxxxxxx using ADSM_MGMTCLASS DB2"
> 2) to start the DB2-backup =>
> "db2 backup database xxxxxxxx use adsm "
> (where xxxxxxxx is the databasename)
>
> Everything works fine to the DB2-Admin... (even the restore!)
>
> Now my problem as TSM Admin =>
> Although in the Managementclass DB2 (backup copy group) is defined, that the
> files are deleted after one day - ALL Files from the beginning are still saved
> in the TSM-Storagepools. And the amount is really huge !
> This is the query of the Copygroup =>
>             Policy Domain Name: STANDARD
>                Policy Set Name: ACTIVE
>                Mgmt Class Name: DB2
>                Copy Group Name: STANDARD
>                Copy Group Type: Backup
>           Versions Data Exists: 5
>          Versions Data Deleted: 1
>          Retain Extra Versions: 1
>            Retain Only Version: 1
>                      Copy Mode: Modified
>             Copy Serialization: Shared Static
>                 Copy Frequency: 0
>               Copy Destination: BACKUPPOOL
> Last Update by (administrator): WOLKE
>          Last Update Date/Time: 2001-01-26 12:13:12
>               Managing profile:
>
> (Notice: The node is assigned to the Policy Domain STANDARD!)
>
> Why doesn't TSM use the defined policy-information and delete the files in 
> this
> case ?
>
> One thing I remarked:
> When you delete a "normal" filespace, then the files are only marked as 
> deleted
> and they are logically deleted from the database when the EXPIRE INVENTORY
> occurs.
> BUT - now I deleted a DB2-Filespace and all the tapes, where the DB2-Data was
> stored, are now empty, WITHOUT the EXPIRE INVENTORY process.
>
> Our Server-Configuration is:
> ..) OS/390 V2 R9.0
> ..) Tivoli Storage Manager for MVS, Version 3, Release 7, Level 4.0
>
> Any suggestions, what's going wrong ? (The problem is, that one backup uses 4
> GB........and after 100 days, we had 400 GBs of data stored!)
> Thanks in advance...
>
> Gerhard Wolkerstorfer