Hi All

I am trying to expire all my data except the latest active version. My
backup copy group settings are as follows:-

Policy Domain Name WINDOWS
Policy Set Name ACTIVE
Mgmt Class Name WINDOWS
Copy Group Name STANDARD
Versions Data Exists 1
Versions Data Deleted 0
Retain Extra Versions 0
Retain Only Version 0
Copy Mode MODIFIED
Copy Serialization DYNAMIC
Copy Frequency 0
Copy Destination WINDOWS
Last Update Date/Time 2002-12-20 07:52:24.000000
Last Update by (administrator) ADMIN Managing profile -

However when I use a select statement just to look at one file to see its
status this is what I see:-
select * from backups where node_name='ALSBCK' and ll_name='BOOT.INI'

        Operation Results


      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: ACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 28209279
    BACKUP_DATE: 2002-12-20 00:10:03.000000
DEACTIVATE_DATE:
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 21347128
    BACKUP_DATE: 2002-10-29 19:41:41.000000
DEACTIVATE_DATE: 2002-11-04 23:57:37.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 22179567
    BACKUP_DATE: 2002-11-04 23:57:37.000000
DEACTIVATE_DATE: 2002-11-05 21:13:14.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 22618038
    BACKUP_DATE: 2002-11-05 21:13:14.000000
DEACTIVATE_DATE: 2002-11-06 19:36:13.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 22875347
    BACKUP_DATE: 2002-11-06 19:36:13.000000
DEACTIVATE_DATE: 2002-11-11 19:41:46.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 23481388
    BACKUP_DATE: 2002-11-11 19:41:46.000000
DEACTIVATE_DATE: 2002-11-19 17:15:50.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 24304303
    BACKUP_DATE: 2002-11-19 17:15:50.000000
DEACTIVATE_DATE: 2002-11-29 09:41:35.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 25991488
    BACKUP_DATE: 2002-11-29 09:41:35.000000
DEACTIVATE_DATE: 2002-11-29 23:46:42.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 26097958
    BACKUP_DATE: 2002-11-29 23:46:42.000000
DEACTIVATE_DATE: 2002-12-01 21:59:49.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 26259332
    BACKUP_DATE: 2002-12-01 21:59:49.000000
DEACTIVATE_DATE: 2002-12-02 23:07:36.000000
          OWNER:
     CLASS_NAME: DEFAULT

      NODE_NAME: ALSBCK
 FILESPACE_NAME: SYSTEM OBJECT
   FILESPACE_ID: 3
          STATE: INACTIVE_VERSION
           TYPE: FILE
        HL_NAME: \
        LL_NAME: BOOT.INI
      OBJECT_ID: 26442741
    BACKUP_DATE: 2002-12-02 23:07:36.000000
DEACTIVATE_DATE: 2002-12-05 12:05:07.000000
          OWNER:
     CLASS_NAME: DEFAULT


There is still a whole lot of inactive files available some as far back as a
month. The expire command i'm using is <expi i w=n> and some files where
delete according to the query process however nowhere near enough as can be
seen from the select statement.

Help I need to get this done to restructure our TSM server:-


Kind Regards
LAWRIE SCOTT