The versions should be deleted 3 days after expiration from the TSM server
database. When were they actually expired? Verbose dsmsched.log would show
this, assuming scheduled full incremental is used to perform the backup
that would have expired the files. Also, are you sure those files are
bound to SQLBACK?

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 07/03/2008
06:30:16 AM:

> Have a mgmt class defined that was working but for some reason it
> appears
> to not be.
>
> Shouldnt the first 3 entries be expired ? They are bound to SQLBACK
>
> Based on this definition any file bound to SQLBACK should be deleted
> from
> TSM if the file has been deleted from the file system more than 3 days
> ago.
>
>
> Policy    Policy    Mgmt      Copy      Versions Versions   Retain
> Retain
> Domain    Set Name  Class     Group         Data     Data    Extra
> Only
> Name                Name      Name        Exists  Deleted Versions
> Version
> --------- --------- --------- --------- -------- -------- --------
> -------
> NT        ACTIVE    SQLBACK   STANDARD         1        1        0
> 3
> NT        NT        SQLBACK   STANDARD         1        1        0
> 3
>
> Output from dsmc command
>
> dsmc delete backup "d:\backups\fsrtest\*.bak" -pick -fromdate=01/01/1990
> -todate=07/03/2008 -deltype=all -su=yes
>
>   #    Backup Date/Time        File Size A/I  File
>      1. | 06/25/2008 21:32:43       1.33 MB  I
> \\rhea\d$\Backups\FSRTest\FSRTest_backup_200806251900.bak
>      2. | 06/26/2008 20:59:56       1.33 MB  I
> \\rhea\d$\Backups\FSRTest\FSRTest_backup_200806261900.bak
>      3. | 06/27/2008 21:07:15       1.33 MB  I
> \\rhea\d$\Backups\FSRTest\FSRTest_backup_200806271900.bak
>      4. | 06/30/2008 21:45:30       1.33 MB  A
> \\rhea\d$\Backups\FSRTest\FSRTest_backup_200806301900.bak
>      5. | 07/01/2008 20:55:04       1.33 MB  A
> \\rhea\d$\Backups\FSRTest\FSRTest_backup_200807011900.bak
>      6. | 07/02/2008 21:00:27       1.33 MB  A
> \\rhea\d$\Backups\FSRTest\FSRTest_backup_200807021900.bak
>      7. | 07/03/2008 09:00:27       1.33 MB  A
> \\rhea\d$\Backups\FSRTest\FSRTest_backup_200807031900.bak
>
> Tim Brown
> Systems Specialist - Project Leader
> Central Hudson Gas & Electric
> 284 South Ave
> Poughkeepsie, NY 12601
> Email: tbrown AT cenhud DOT com <mailto:tbrown AT cenhud DOT com>
> Phone: 845-486-5643
> Fax: 845-486-5921
> Cell: 845-235-4255
>
>
>
> This message contains confidential information and is only for the
> intended recipient.  If the reader of this message is not the intended
> recipient, or an employee or agent responsible for delivering this
> message to the intended recipient, please notify the sender immediately
> by replying to this note and deleting all copies and attachments.  Thank
> you.